I have a form in Access 2000 that pulls its data from a query named Misd the query asks the user for a date range to query. Hence, when the report is ran it asks for the date range.
What I would like to do is to have the the report header include the date ranges input by the user. So it says "Data for the dates of 1/1/04 through 1/30/04" or the like.
I tried a min/max however that only gave the the date ranges of the matching records. (of course) I realized this after trying (Blush)
Here is the portion of the code that asks for the date range...
WHERE (((stats.Date) Between [Please enter the beginning date] And [Please enter the ending date])
(I know the Parenthesis look wrong but there is another criteria after the date.)