setting criteria between dates

A

Aaron D.

I am trying to set a critieria in a query to list data in between dates.
in the critieria box i entered in the following formula:
Between #2/1/2007# And #2/28/2007#
it is not filtering ANYTHING, the query look exactly the same, although is
does list less records But i can see what it took out. And it is NOT listing
only Feb.
Thank you for the help!
 
R

Rick B

Do you have any other criteria on another row in the query screen? That
would create an "OR" condition which usually results in more records being
displayed.

Your field *IS* a date field, right?


If that is not it, open your query and select View/SQL View. Copy the SQL
and paste it into a message here so we can see it.
 
A

Aaron D.

Ah! I do have more criterias on other rows... Ok so how do get the date one
to be first and formost with the other criterias coming to affect AFTER the
date criteria?
And yes the field is exclusively a date field.
Thak you Rick for taking the time
 
R

Rick B

To create *AND* conditions, put all the criteria on the same row.

If you want an or condition on a couple of fields *and* the valid date
range, then you will have to put the date range on each of the criteria rows
and the other conditions on separate rows.

Read across the grid....

If Field1 is X, and Field2 is Y and Field3 is Z...

Then, when you jump to the next row you would read an "OR", then all the
conditions on the second row separated by "and"s.

Hope that helps. Again, feel free to post the SQL and we can fix it for you
and you can paste it back in. then, when you return to the grid view,
you'll see how it was done!
 
A

Aaron D.

Hey Thanks I got it working! I should have thought of that, it's all logical
right? LOL...
 
Top