Quotes inside SQL statememt...

[wwg]

This expression is part of an SQL statement copied from the SQL view of a
working make-table query. I can't get it to compile as a direct SQL query.
The quotes seem to be the problem. Replacing them with single quotes allows
the query to run but it no longer works properly then.

"IIf(IsNull([Salutation]),"", [Salutation] & " " & [FName2] & " " & [Last
Name] & " " & [Title] AS Expr2, "

What to do?

Thanks --Wesley

 

[Ken Snell]

Double up the " characters so that ACCESS will "see" them as a single "
character when it creates the text string:

"IIf(IsNull([Salutation]),"""", [Salutation] & "" "" & [FName2] & "" "" &
[Last
Name] & "" "" & [Title] AS Expr2, "

 

[wwg]

Ken:

Right. It now works fine. Thanks for the prompt response.

--Wesley

Double up the " characters so that ACCESS will "see" them as a single "
character when it creates the text string:

"IIf(IsNull([Salutation]),"""", [Salutation] & "" "" & [FName2] & "" "" &
[Last
Name] & "" "" & [Title] AS Expr2, "


--
Ken Snell
<MS ACCESS MVP>

This expression is part of an SQL statement copied from the SQL view of a
working make-table query. I can't get it to compile as a direct SQL query.
The quotes seem to be the problem. Replacing them with single quotes allows
the query to run but it no longer works properly then.

"IIf(IsNull([Salutation]),"", [Salutation] & " " & [FName2] & " " & [Last
Name] & " " & [Title] AS Expr2, "

What to do?

Thanks --Wesley