More than 9 OR Criteria in Design View

A

Andy

Is it possible in Design View to list more than 9 OR criteria without using
SQL? I have 12 fields and need to apply a criteria to each one to see if a
specific value is included in any of the fields.

Only way I can think of is to run the query for the first 9 and append that
result to querying the last 3.
Thanks
 
J

John Spencer

It sounds as if you are using the query grid. To add rows to the criteria
section, select Insert: Rows from the menu.

To add multiple rows to the grid at one time
-- put the cursor at the very left edge of the criteria grid, so you can see
a right-pointing arrow
-- drag down (or up) to select multiple rows
-- select Insert: Rows from the menu
 
A

Andy

Sometime you look for the complicated things in life and miss the most
obvious and simple solutions!

Thanks
 
D

David F Cox

it may not be relevant but you can do:

"USA" IN ([source],[ordered],[destination], ....)
 
Top