Date Problem on Report

  • Thread starter Thread starter Andree
  • Start date Start date
A

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.
 
Any chance the dates for the 31st also include time? If so, try BETWEEN
#7/1/2003# AND #8/1/2003#
 
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!!
 
It did work. The reports now work for 31 day months just
by eliminating the time from the data entry field.
Thanks!
 
Back
Top