Query OR Field Limit - Microsoft Access Beginner 5


	Back to Access Beginner 5 Comments List

Upload Images @Reply Bookmark Link Email

Query OR Field Limit

Colby Wolford

3 years ago

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?

	Richard Rost @Reply 3 years ago
Right. At a certain point you're going to want to make it a separate related table or use DLookup

	Kevin Yip @Reply 3 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.

	Kevin Yip @Reply 3 years ago

	Richard Rost @Reply 3 years ago
It gets tricky though if you've got other fields with criteria too.

	Colby Wolford OP @Reply 3 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).

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Beginner 5.