How to make a quary to get report for specific time period?

  • Thread starter J.A.Pandya - Mechanical Maint. Engineer
  • Start date
J

J.A.Pandya - Mechanical Maint. Engineer

I am using Microsoft access 2003. I want to prepare report between two dates.
How can I get the report between specific dates?
 
J

JohnFol

Have a look at the "Sales By Year" report in nWind. It does exactly that

"J.A.Pandya - Mechanical Maint. Engineer"
 
J

Jeff Boyce

In the query design window, use a criterion for the date field that looks
something like:

Between [FromDate] And [ToDate]

This will prompt the user for the two dates ([FromDate] and [ToDate])

--
Good luck

Jeff Boyce
<Access MVP>

"J.A.Pandya - Mechanical Maint. Engineer"
 
Top