Filtering Between 2 dates

B

bullhakow

Hi,

I've created a query to only display the data between 2 dates.

So In the design view In the Date field in the Criteria box I typed:

Between #4/3/2004# And #4/23/2004#

But when I view the query it comes back empty.

Thanks for your help
 
A

Allen Browne

The expression is correct (assuming you use US dates).

In the table, this is a Date/Time field (not a Text field)?
Or is it a calculated date field in the query?

Any record from Apr 23 that have a time component won't show.

Are there multiple tables in this query? If so, what kind of JOIN? And which
table does the date come from (main or related)?

Does a compact and repair help? (It could if the date field is indexed, and
the index is damaged.)
 
Top