Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Solved
Use Chr(39) for single quote.
UPDATE: I guess you are using Concat function or GetFieldSelections may be?
Try this if its Concat:
Concat(Chr(39) & FieldName & Chr(39), ',')
or this if it is GetFieldSelections:
Chr(39) & GetFieldSelections(FieldName, Chr(39) & ',' & Chr(39), 1000000) & Chr(39)
Using Chr(39) will work, just as Sunny suggests. A second possibility is to use an escape sequence in your Set or Let statement. See Escape sequences
HIC