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...
 
Did you try "091S" alone? It should return both upper and lower case.
 
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.
 
You must log in or register to reply here.

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

Similar Threads

Access Dcount (multiple criteria) 3
not in criteria fails 2
select query including dates outside of specified range 2
Criteria to return all records if selection from form is null 3
Query Criteria 2
True, False, or Both criteria 4
Update query with date criteria 3
Query returns wrong records 4

Back
Top