how do i query an access database by date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several databases of agent statistics and there are times that I only
want to run a query (and then a report) for specific dates. I have a date
field named Quality week for the one I use the most but don't know how to
quantify my query for the dates I want. For example, February 27th through
March 27th with the dates in the database as 2/27/05 and 3/27/05.
 
Just add criteria to your query like...

Between [Enter Start Date] and [Enter End Date]


The user would then enter the date range desired.

Rick B
 
Thank you Rick. I am very surprised but very happy that it is that easy!

Rick B said:
Just add criteria to your query like...

Between [Enter Start Date] and [Enter End Date]


The user would then enter the date range desired.

Rick B


Trbecker2 said:
I have several databases of agent statistics and there are times that I only
want to run a query (and then a report) for specific dates. I have a date
field named Quality week for the one I use the most but don't know how to
quantify my query for the dates I want. For example, February 27th through
March 27th with the dates in the database as 2/27/05 and 3/27/05.
Click to expand...
Click to expand...
 
Back
Top