Access report will not display all dates in the paramater

A

Alecia

I have created a report based on a query with start and ending dates. The
report will pick up all dates except for 11-22-04??? All the rest of the
dates for the year work just fine. Any suggestions.
 
R

Rick B

You don't tell us what criteria you are entering. I would assume that 11/22
is probably being entered as your "to" date.

As discussed recently in this group (you can search for this) the field is
actually date and time. If you only store the date, then it assumes a time
of midnight. This can cause trouble when trying to use 'between' in a date
query.

Rick B
 
R

Rick B

Here is a snip from a post that explains what I meant. Not sure if this is
your issue or not...


----------------------------------------------------------------------------
--
Is it possible that your date field values contain a time element in
addition to the date? If so, you should use your criteria against a
calculated column like:
DateYourField:DateValue([YourField])
Between .....
 
Top