Full Version: SQL with quotes
UtterAccess Forums > Microsoft® Access > Access Forms
phantomodopera
I'm having a problem with the following due to the quotes in the IIF
Me.lboxBusniess.RowSource = "SELECT tblBusiness.ID, tblBusiness.Business, IIf([Custom1],"X","") AS cust1, IIf([Custom2],"X","") AS cust2;"
What would be the right way to due this?
theDBguy
You have to use single quotes inside double quotes, such as:
SELECT tblBusiness.ID, tblBusiness.Business, IIf([Custom1],'X','') AS cust1, IIf([Custom2],'X','') AS cust2;"
HTH
phantomodopera
thats it.
Thanks!
theDBguy
You're welcome. Good luck with your project.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.