Parameter v Form

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

1. Create a query to use as the RecordSource of your report.
   
2. In query design view, in the Criteria row under your date field, enter:
   
   Between [StartDate] And [EndDate]
   

The other is to create a specific form. The unbound form has the following advantages:

• 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.
  

Allen Browne has supplied a clear explanation along with some typical code.

Also see FontStuff.com:
Using Parameter Queries



See all Topics