Micron seems to be saying that isn't the problem, but you didn't actually use the technique in the link. You applied it to a variable, but you don't use that variable in the SQL (plus you overwrote the variable with another value anyway).
Who is John Galt?
Windows XP 
Access 2007
Micron seems to be saying that isn't the problem, but you didn't actually use the technique in the link. You applied it to a variable, but you don't use that variable in the SQL (plus you overwrote the variable with another value anyway).
Novice
Windows Vista Access 2003
Hello Paul and Micron, I was looking at the dates the query generated and noticed that the day increases by increments of 1, the month was always January and the year increases by increments of 1 when needed. Thenit finally clicked what Paul has been saying to change my System Date to English (United States). I ran my query and it worked.
Thank you so much for your help and patience,
Luisa
Very Inert Person
Windows 7 32bit Access 2007
Your date settings are independent of the language and regional settings, but by changing to US, you adopted the required date setting by default. You can choose Canadian settings (which will affect which dictionary you use) and still have the date format required since it's a separate option. I have English(Canada) setting, and the function worked properly for me. Just so you know.
Master of Nothing
Windows XP Access 2010 32bit
Maybe this will help
Microsoft Access Tips for Serious Users
find Dates in Strings at
http://allenbrowne.com/ser-30.html
Pass VBA variable to Public Variable and pass to Access 2007 Append Query attached to a form.
Pass a parameter to a pass through query using a form
Insert Pass-Through Results into Access Table with VB
Posting Permissions
Reply With Quote