 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Security / February 2008SQL Error
I am trying to save custom reports to a table but I get a syntax error due to the sinqle quotes. How can I get around this error? "INSERT INTO [MyReports] (ReportName, Report, Filter) Values ('test","CalDueListInfo_Query","(F12 = '21LR13' AND F22 = 'ON-SITE')")" I want the User to be able to open saved report and apply the custom filter. Hey all, I found my error. > I am trying to save custom reports to a table but I get a syntax error > due to the sinqle quotes. [quoted text clipped - 5 lines] > > I want the User to be able to open saved report and apply the custom filter. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.