I was testing out a Query and decided to just keeping listing state name abbreviations in the Query Design OR fields. I understand that if you have a lot of OR conditions, you may want to rethink how you're parsing the data. However, are Queries limited to only 8 separate OR conditions?
Right. At a certain point you're going to want to make it a separate related table or use DLookup
Kevin Yip
@Reply 4 years ago
You can have as many you want if you put several OR conditions in one line, as shown in the picture below. Or you can write them in SQL, and use as many criteria as you need.
It gets tricky though if you've got other fields with criteria too.
Colby WolfordOP
@Reply 4 years ago
Thanks for the quick confirmation! Much appreciated!
And thank you for the sample SQL code image, Kevin. I love getting more information and seeing code snippets that I can refer to when I get better at things (like programming).
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 5.
