iif in a VBA query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,
i want to use an SQL query using VBA. how I will use the quotes?
eg. SQL="SELECT IIF([OK]>10, "GOOD","BAD") AS RESULT, NAME FROM USERS"
The quotes in the iif statement return me an error(too few parameters). How
I will fix it?
 
For embedded quotes, double them up:

SQL="SELECT IIF([OK]>10, ""GOOD"",""BAD"") AS RESULT, NAME FROM USERS"
 
Thanks a lot Ken !!!

Ken Snell said:
For embedded quotes, double them up:

SQL="SELECT IIF([OK]>10, ""GOOD"",""BAD"") AS RESULT, NAME FROM USERS"

--

Ken Snell
<MS ACCESS MVP>


Stelios said:
hi,
i want to use an SQL query using VBA. how I will use the quotes?
eg. SQL="SELECT IIF([OK]>10, "GOOD","BAD") AS RESULT, NAME FROM USERS"
The quotes in the iif statement return me an error(too few parameters). How
I will fix it?
Click to expand...
Click to expand...
 
Back
Top