Creating a query for giving data between two specified dates

Hello Graeme,

Hope you enjoyed your Microsoft Access courses with Best STL.

Thank you for your question regarding querying date data. When you created the query I assume you used square brackets [] to define the parameter for the manual entry of the dates. If you wish to create a query without parameters then select the criteria section of the date field and type the following:

Between #01/04/2004# And #31/03/2005#

This will only select data for that year. You will then have to create separate queries for each year since you will using these queries to produce individual annual reports.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer