Forum Discussion
Inherited a Access databse, cant get it to generate multiple reports off a date range.
As the subject line states, I inherited a Microsoft Access database that assists me in printing a list of names based off where people work. I have an input form that generated a lot of information b...
Hi,
I had hoped George would bite the bullet. 😉
So, your SQL text for the report shows that the parameters from the form controls (zone, facility, facility2) are used there for filtering. Of course, there is no sign of your date controls there yet.
The first question is why, according to your description, there is only 1 record in the report with this filter data, the other is which of these form controls you still need for filtering, in addition to the date range. If we know this, we can perhaps adapt the SQL text as desired.
Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEK
I believe the date aspect was an afterthought and is directly tied to the Filled out form for filtering and not to the query at all.
When I pull the report in the normal use of the form, it gives me all active employees for that specific filter set. Thats why there is only one record. It was designed previous to my obtaining it to have multiple records but anything beyond the first record only gave extra blank lines. All the other filters are working properly.
The "date box" at the top of the In and out section is directly tied to the Fillable form and not the query table.
When I pull the report in the normal use of the form, it gives me all active employees for that specific filter set. Thats why there is only one record. It was designed previous to my obtaining it to have multiple records but anything beyond the first record only gave extra blank lines. All the other filters are working properly.
The "date box" at the top of the In and out section is directly tied to the Fillable form and not the query table.
