Access report will not display all dates in the paramater

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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 .....
 
The 11/22/04 is a date. The report will pick up all other dates in the
database related to the Date field except the 11/22/04 date. The report asks
for a start date and an ending date. All of the yearly dates work except the
11/22/04. This is weird to me.

thanks for your help thus far

alecia
 
Back
Top