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
Default

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