Users select date range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Range in Query using DateAdd 4
Date Criteria 5
Using 'Between' for filtering dates 5
Start Date/ End Date query 7
Date Range Query Not Returning Correct Results 2
Changing Year in Date Range 1
extract date then search by the date 6
Nested If Statements II 5

Back
Top