Users select date range

D

Dispatcher Scott

I have created a query and I have placed [enter date] in the "criteria" so
that when the query is ran, the user has to select a specific date to return
those results.

My question is, how can I create a similar query where the user can search
for a date "Range" (i.e. 08/01/2007 through 08/31/2007) and then have the
results displayed?
 
J

Jeff Boyce

In the query, in the Selection Criterion "cell" under the date field, put
something like:

Between [Enter Starting Date] And [Enter Ending Date]

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top