First timer

D

douglas06

Joined
Aug 24, 2005
Messages
1
Reaction score
0
Selecting Date ranges??

Can someone help me, I have a date field in an access program I have written. I want to write a query which will enable the user to enter a range (start date then end date) and the query will only show records in that range.

Thanks.
 
Last edited:
In the 'Date' criteria field on your query, put in:

Between [Start Date] And [End Date]

When you run the query, it should now ask you for a start date, followed by an end date. This should solve your problem!
 
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

Date Range - Between Start and End 5
Create a Query that Prompts for Date and Time 4
How to filter on calculated dates 3
Dcount returning no results!!! 0
Duplicate prompts in crosstab query and subsequent report 1
>=[BeginDate] And <=[End Date] 1
show criteria data from a query on a report using that query 2
Using Between Dates in a Query 4

Back
Top