Prev: Compare dates in two seperate records
Next: Query between 2 tables with one-to-many relationship
From: RC on 21 Apr 2010 14:37
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

From: KARL DEWEY on 21 Apr 2010 14:58
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
>
From: RC on 21 Apr 2010 15:22
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
> >
 | 
Pages: 1
Prev: Compare dates in two seperate records
Next: Query between 2 tables with one-to-many relationship