Date Problem on Report

[Andree]

I have a monthly report that gets the information from a
query from multiple tables. When I have a month where
there are 31 days in that month, I don't get a correct
number - it omits information where data entry occurred on
the 31st of any month. I use: Between #7/1/03# and
#7/31/03#. When I use the same criteria for a 30 day
month, I get all the information, including the 1st and
the 30th, where data was entered on those days.
Can anyone help troubleshoot this problem?
Thanks in advance.

 

[Douglas J. Steele]

Any chance the dates for the 31st also include time? If so, try BETWEEN
#7/1/2003# AND #8/1/2003#

 

[Andree]

Yes, the data entry field includes a time. I'll just
change the field properties to exclude the time and see if
that works. Thanks!!

 

[Andree]

It did work. The reports now work for 31 day months just
by eliminating the time from the data entry field.
Thanks!