Y2k in Access 2003

[raminriahi]

Hi.

when i design a query in access 2003 and filter one date field (between #1/1/1992# and #12/31/2001#) it ignores all the records >=1/1/2000 . is this a Y2K problem? and what's the solution? is there any settings to come over this problem?

** not to mention that the query works fine in Accesss 2000.

Thanks in advance,

Ramin

 

[JerryKlmns]

Filtering using

between #1992-01-01# and #2001-12-31#

has the same effect?

 

[raminriahi]

The date format wasn't the issue.

Thanks anyway Jerry!