How do I add quotes as a constant in an expression?

G

Guest

example: I want quotes at the end of a number. If I want a space I put the
field name in, then & then " ", but if I want quotes and a space, I tried &
"" " and this gives me an error
 
M

Marshall Barton

DenieceTX said:
example: I want quotes at the end of a number. If I want a space I put the
field name in, then & then " ", but if I want quotes and a space, I tried &
"" " and this gives me an error
Click to expand...


Inside quotes you need to use two quotes:

field & """ "
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ConcatRelated: How do I add an additional field? 0
How to include double quotes in an expression 1
Need a quote in my expression 3
use expression as field name in query 2
Deleting commas within quotes 2
How do you index an term containing quotes? 5
Query builder enclosing fieldnames in quotes 3
How to refer to an existing field name containing an illegal chara 1

Top