Criteria Question

[Mark]

Hello All,

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

 

[Marshall Barton]

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

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.

 

[John W. Vinson]

Hello All,

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

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?

 

[John Spencer]

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
'====================================================