You have a choice
There are a couple of ways to limit the data that is displayed in a Query or in a report.
One is a Parameter Query
- Create a query to use as the RecordSource of your report.
- In query design view, in the Criteria row under your date field, enter:
Between [StartDate] And [EndDate]
- Flexible: user does not have to limit report to from and to dates.
- Better interface: allows defaults and other mechanisms for choosing dates.
- Validation: can verify the date entries.
Also see FontStuff.com:
Using Parameter Queries
See all Topics