Will not show 2004 dates

  • Thread starter Thread starter Jena
  • Start date Start date
J

Jena

We use access to keep track of all of our customer
jobs....when an order comes in, the info is entered which
includes the ship date. We have a report that we run
where we enter the date and it shows us what will ship
for that month (ex. 12/1/03 to 12/31/03...shows us what
needs to ship and the dollar amount of whats shipping)
Whenever I try to do anything for 2004, everything comes
up with errors? I can enter orders for 2004, but can not
run any reports. Is there somewhere that I can change
this?? Or how do I fix it?? Please help.
 
"Everything comes up with errors" is not very descriptive. Access will, of
course, store and manipulate dates for 2004.

How are you opening the report? If it's through a button click, check the
code behind that to see what's going in (for example, if a Where clause is
being used that would cause this trouble). If you're opening the report by
double-clicking in the database window, then you'll want to open the report
in Design view and examine the recordsource. If necessary, post your code
and the recordsource of your report.
 
Back
Top