More than 9 OR Criteria in Design View

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Sometime you look for the complicated things in life and miss the most
obvious and simple solutions!

Thanks
 
it may not be relevant but you can do:

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