Graeme has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Creating a query for giving data between two specified dates
Afternoon.
I know how to run a query which creates a 'pop up' box asking me to enter two dates and gives the result between those dates, but I would like to run a query in which I can enter specific dates within the query, so it automatically runs with those dates each time.
For example, I have a table spanning 5 years. I would like to extract data april 04 to march 05, then april 05 to march 06 (tax years). I tried running a query and entering those dates and creating a report, but when I save and close, then open the report again, it asks me to enter dates again, when I'd really like it to stick to those dates.
I hope that is clear but am happy to clarify anything.
Thanks,
Graeme
RE: 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
