Prompt a Date Range

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

Guest

I am using Access 2000. When I run a query, I would like it to prompt me for
a date range and pull only those records.
 
Use this as criteria ---
Between [Enter start date] And [Enter end date]

If you enter a date in a format that Access recognizes it will work.
 
You must log in or register to reply here.

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

Duplicate prompts in crosstab query and subsequent report 1
Date Range 1
Update query should not fire if prompt is null 1
Prompting for date range twice 3
User Prompt for Month to find Date Range 3
Crosstab query by date range 7
Create a Query that Prompts for Date and Time 4
Crosstab Query based on Query 4

Back
Top