In what way isn't it respecting Regional Settings?
If you're talking dates, then yes, you must use mm/dd/yyyy in queries
(although an unambiguous format serves as well). See Allen Browne's
"International Dates in Access" at http://allenbrowne.com/ser-36.html or
what I had in my September 2003 Access Answers column for Pinnacle
Publication's "Smart Access" newsletter. (The column and accompanying
database can be downloaded for free at http://www.accessmvp.com/djsteele/SmartAccess.html)
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.
