Special Characters in Access 2007

  • Thread starter Thread starter RC
  • Start date Start date
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
 
Try this as criteria --
'1"'
That is single quote, number, double quote, and end with single quote.
 
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
Click to expand...
Click to expand...
 
Back
Top