How do you get more rows in the query desinger when having many ORonditions

[Pack10]

I have a query with a lot of fields that have an OR condition in the query designer. I need more rows, how do i get more rows, and I have about 7 fields of criteria, does the criteria
have to be in every row that there is the or condition. For example, the query will have about 30 rows, so each field drops 1 row for the OR condition. Does the criteria need to go down
for each row. I think it does.

Field1 Field2 Field3 Field 4 Field 5 Field 6 Field 7
"Yes" Is Null Is Null <> Major
"Yes" Is Null Is Null <> Major
"Yes" Is Null Is Null <> Major
"Yes" Is Null Is Null <> Major

If that query goes across 30 fields do I have to match the criteria 30 times....and how do i get more rows in the query designer. Or is there a better way? Thanks

 

[dhookom]

There is a button in query design (Access 2007 and others) to Insert Rows.

This sounds a bit unusual to require so many OR's. I assume you know your tables and how to keep them normalized.

Duane
Hook'D on Access
MS Access MVP