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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 dimensional date sort 2
Help showing active months between two dates 5
Help creating a search form in Access XP 0
Find the position of a date 6
Compound IIF Statement 2
"Between...and" operator problem 3
Cross Tab Query 4
Reversing Dates Sequence along X axis in a chart 3

Top