trouble querying date in access xp after 97 conversion

P

PamP

when querying in access xp after converting from access 97,
the month part of date is confused. When querying for Dec
data it results in Feb and Dec data. When querying for Nov
data it results in Jan and Nov data.
 
G

GVaught

what is your criteria statement to pull the records? Is the field where the
date is located a text field or is it a date/time field?
 
Top