Union Query - Date Parameters

[Yoplumpy]

Hi

Any help on this would be greatly appreciated.

I have a database that is a main core table and linked to 4 different types of attendance (don't ask!). The user will enter the date for the attendance type and mark it as "1" for present etc.

All have the same field names - including Attendance Date.

I know the database structure isn't ideal...

I need to count all the attendances that have occurred in a defined period. The attendance dates have been reformatted to give the month.

I have created a union query to combine all of the data but if I add parameters these have to be added 4 times - is there any way it could accept the date range once? I would then look to create a cross tab based on this query.

Help gratefully received!

Paul

 

[pbaldy]

Not sure why it's an issue to have the parameters in each section, but if you want you can create the UNION query without parameters and base another query on the UNION query. If your issue is getting prompted 4 times, you can have the user enter the parameter(s) on a form and have the query get them from there.