Search between two dates query

G

Greg

i have a query looking for data between two date ranges
eg all data between 1/3/04 and 31/3/04 being 1 month
i am currently usin the following query critera
in the date feild = between [startdate] and [enddate]
the above works but its sending me all data that starts
with the first and last number but in ANY month eg
1/1/04
1/2/04
1/3/04
all dates between 1 and 30 with all months
30/1/04
30/2/04
30/3/04

i only wont date between 1/3/04 and 30/3/04

can anyone help...
 

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 query 1
Between dates 7
display records from a query 1
Access Count dates within a Month 4
Query all dates 2
Formula to report dates in a new tab 2
Query to display the difference of period for an employee. 1
2 quesions about query 2

Top