How to add Criteria 'rows' in a Query?

[mjchristinaj]

Hi,

I want to do a Select Query without VBA, just using the wizard. The problem that I find is that I need to do more "OR" statements than 'rows'of criteria. Is there a way to add new 'rows'of criteria?
I have 9 rows to do "OR" statement, but I need to do 10 "OR" statements.

Cristina

 

[bob fitz]

You could try this:

Instead of putting each of the criteria on a new line, put it all on the first line with something like this for numeric values:

1 Or 2 Or 3 Or 4 Or 5 Or 6 Or 7 Or 8 Or 9 Or 10

Or something like this for text values:

"a" Or "b" Or "c"

 

[plog]

You could also put all those values in a new table and do an INNER JOIN between that table and the one you want to apply the criteria to.

 

[Dhamdard]

The easiest way is to insert row. Put your cursor in one of the rows of criteria, and then click 'Insert Rows' from 'Query Setup' group under 'Design' menu. You can insert as many rows as you need.

Hamdard