|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 21st, 2010, 07:37 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Special Characters in Access 2007
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 
|
|
#2
April 21st, 2010, 07:58 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Special Characters in Access 2007
Try this as criteria --
'1"' That is single quote, number, double quote, and end with single quote. -- Build a little, test a little. "RC" wrote: 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
|
|
#3
April 21st, 2010, 08:22 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Special Characters in Access 2007
Worked like a charm. Thank you!
"KARL DEWEY" wrote: Try this as criteria -- '1"' That is single quote, number, double quote, and end with single quote. -- Build a little, test a little. "RC" wrote: 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
