View Single Post
Old 05-29-2016, 11:57 AM
PlausiblyDamp's Avatar
PlausiblyDamp PlausiblyDamp is offline
Ultimate Contributor

Forum Leader
* Expert *
Join Date: Nov 2003
Location: Newport, Wales
Posts: 2,058

If you actually look at the variable sql in a debugger and then try running your generated sql directly against the Access dtabase in question does it work?

Looking at the code you have posted however you might be adding some unneeded ' charcters around the date variables.
Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein

Posting Guidelines Forum Rules Use the code tags
Reply With Quote