date recognition problem in Access 2007

[Norm Sund]

I have a database made in ms 2003, i installed ms2007 and now the querry does
not recognize dates in the year 2010.... anyone have similar problem and find
a solution?... in 2003 i enter date as 09012009, for sept 1 2009, when i put
in the date in ms2007 after 12312009 it says error on my report ( no error
number)
example of date enter for year 2010 is 01012010

 

[John Spencer]

What does it say if you just run the query for the report?

Does the query run?
Does it return records?
Does it generate an error?

If the query works, then you need to look at the report. Could it be that no
records are being returned and that is the cause of ERROR showing on the report?

I'm concerned that you are entering 01012010 as a date entry. What type of
field is the field where you are storing the date? If the field was a
DateTime field, you would need to enter the date with some delimiter
characters between the Month and day AND between the day and year.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County