Special Characters in Access 2007

R

RC

I'm working on a database that has fields filled in with sizes (i.e. 1.5",
2", 3", etc.)
I know the " shouldn't have been used but it was.
When writing a query to show only 1" items I get the message "The expression
you entered has an invalid string." I usually can get past this by putting
the " in brackets (like this ["]) and I could go on, but now that I am using
access 2007 (was on 2003) I get this message; "The expression you entered
contains invalid syntax." I've tried to manually add the outside quotes but
that doesn't seem to work. When I look up the second message it gives the
special character fix, using brackets.
Any help is appreciated.

Thanks
RC
 
K

KARL DEWEY

Try this as criteria --
'1"'
That is single quote, number, double quote, and end with single quote.
 
R

RC

Worked like a charm. Thank you!

KARL DEWEY said:
Try this as criteria --
'1"'
That is single quote, number, double quote, and end with single quote.

--
Build a little, test a little.


RC said:
I'm working on a database that has fields filled in with sizes (i.e. 1.5",
2", 3", etc.)
I know the " shouldn't have been used but it was.
When writing a query to show only 1" items I get the message "The expression
you entered has an invalid string." I usually can get past this by putting
the " in brackets (like this ["]) and I could go on, but now that I am using
access 2007 (was on 2003) I get this message; "The expression you entered
contains invalid syntax." I've tried to manually add the outside quotes but
that doesn't seem to work. When I look up the second message it gives the
special character fix, using brackets.
Any help is appreciated.

Thanks
RC
 

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

Top