Criteria Question

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hello All,

In the criteria section I'm using some OR's. Is it limited to only 9? I'm
needing more.
 
Mark said:
In the criteria section I'm using some OR's. Is it limited to only 9? I'm
needing more.
Click to expand...


You casn use as many as you need, but you might have to do
it in SQL view instead of design view.

Depending on what you are tryng to do, it might be easier
and cleaner to use the IN operator instead of a long string
of ORs.
 
Hello All,

In the criteria section I'm using some OR's. Is it limited to only 9? I'm
needing more.
Click to expand...

In the query grid you can select a row (or several rows) and select Insert...
Rows from the menu.

However, you may be better off using a single criterion:

IN(3, 54, 129, 330, 426, <etc>)

or

IN ("Jones", "Rodriguez", "Cho", "Robinson")

depending on the datatype of the field.

What's the context? Where are the nine (or more) values coming from? Could
they perhaps better be in a second table to let you use a Join?
 
Put the cursor in any criteria row
Select Insert: Row from the menu to add one row.

If you need to insert multiple rows, select multiple rows and then
choose Insert: Row from the menu to add multiple rows at one time

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top