E
Edwin Merced
Does Access have a limit to the type of OR conditions in a query?
I am trying to filter 20 criteria but it only allows 7
I am trying to filter 20 criteria but it only allows 7
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Brendan Reynolds
According to the help file, the maximum number of ANDs in a WHERE or HAVING
clause is 99. The help file doesn't specifically mention ORs but I would be
very surprised if it was different. Perhaps you may be running up against
one of the other limits. Search the help file using the keyword
'specifications' to find them.
BTW: What happens when you try? Are you getting an error message?
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
clause is 99. The help file doesn't specifically mention ORs but I would be
very surprised if it was different. Perhaps you may be running up against
one of the other limits. Search the help file using the keyword
'specifications' to find them.
BTW: What happens when you try? Are you getting an error message?
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
E
Edwin Merced
Actually Im jst establishing the criteria in teh table provided by design
view. I am not writing any typ of argument, just using the table
view. I am not writing any typ of argument, just using the table
B
Brendan Reynolds
Same thing, Edwin. When you enter something in the criteria row in the query
design grid, a WHERE clause is created. It doesn't matter whether it is
created manually, by typing the SQL, or graphically, using the query design
grid, it is still a WHERE clause, and still subject to the same
specifications.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
design grid, a WHERE clause is created. It doesn't matter whether it is
created manually, by typing the SQL, or graphically, using the query design
grid, it is still a WHERE clause, and still subject to the same
specifications.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
E
Edwin Merced
But grid does not advance beyond 7 OR criterias
What must I do?
What must I do?
E
Edwin Merced
But when I reach my seventh criteria the table does not move down.
B
Brendan Reynolds
Select 'Rows' from the 'Insert' menu.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
A
Arvin Meyer
In addition to Brendan's solution, you can also use an or on the same
criteria line like:
"Oranges" Or "Apples" Or "Pears"
You can also use an IN clause:
In("Oranges", "Apples", "Pears")
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
criteria line like:
"Oranges" Or "Apples" Or "Pears"
You can also use an IN clause:
In("Oranges", "Apples", "Pears")
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
E
Edwin Merced
THANX GUYS YOu really didi it!!!
Brendan Reynolds said:Select 'Rows' from the 'Insert' menu.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
E
Edwin Merced
Just one more thing. How do I attach a yes no field to a memo field. Lets
say the user clicks the yes no field (with NO) then associate a paragraph
(???a memo field)???)with that NO in a Report
say the user clicks the yes no field (with NO) then associate a paragraph
(???a memo field)???)with that NO in a Report
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.