DateValue

[Guest]

I have a query which pulls records based on >=[ENTER BEG DATE] criteria.

I have changed to read ">=DateValue([ENTER BEG DATE])" but the results are
still not correct.

When entering 4/1/07 it gives me all data from 4/2/07 on.

If I enter 3/31/07 it gives me all data from 3/31/07 on.???

There are records for every date in the range: 3/31, 4/1, 4/2, etc...

What else can I try?

Thanks

 

[Guest]

You must have a time componant in the date fields. The only records included
for the begining date would be those that have a date/time stamp of exactly
midnight.

After that, the records are > but not =