G Guest Feb 24, 2005 #1 I am using Microsoft access 2003. I want to prepare report between two dates. How can I get the report between specific dates?
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 Feb 24, 2005 #2 Have a look at the "Sales By Year" report in nWind. It does exactly that "J.A.Pandya - Mechanical Maint. Engineer"
Have a look at the "Sales By Year" report in nWind. It does exactly that "J.A.Pandya - Mechanical Maint. Engineer"
J Jeff Boyce Feb 24, 2005 #3 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"
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"
