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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook 2016 Calendar printing monthly view 0
Excel Progress Bar Showing Progress of Month 0
Report sums based on record dates 1
Programmatically diff textboxes 4
excel date problem 3
Last day of month in query 15
Graph Printout cuts off right edge 2
Report with disappearing subreports - null values 3

Back
Top