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
Sorry, I was required to spend the day yesterday with my granddaughter, who has first priority in all things. I'll get back on board today, I hope.