Selection Criteria: Problems with Or

  • Thread starter Thread starter Sagebrook
  • Start date Start date
S

Sagebrook

I need to select records where a field equals "091s" or "091S".


Here is what I've tried:

If I use "091s" Or "091S", I only get records with "091s".
If I use "091S" Or "091s", I only get records with "091S".

"091S" Or "081S" gets me both requested sets, so I know the Or can work.

I thought about using Like "091*", but that also returns "091c" which I do
not want...
 
You should show us the full query that you're using here.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)
 
"091S"
didn't work

"091s"
also didn't work

Like "091s"
works and so does
Like "091S"

I still don't understand why the Or statement does not work in this case.
 
Like Sylvain said you need to post the SQL of your query. Open in design
view, click VIEW - SQL View, highlight all, copy, and paste in a post.
 
Back
Top