More than 9 criteria

[ankrumc]

Is there a way to have more than 9 fields of criteria?

Thanks!

 

[Atomic Shrimp]

Just right-click on the grid and insert rows

Edited to add: Well, I could have sworn that used to work.

How complex are your criteria, generally? Can they be simplified so as to put OR operators inside the rows?

 

[ankrumc]

yep, I knew it was right in front of me

 

[Atomic Shrimp]

Does right click work for you? It doesn't seem to be an option in Access 2007

 

[Brianwarnock]

If just looking for values you could use the In function, however if things are more complex and more criteria rows are needed the click into a row and then select Insert then rows from the menu bar.

Brian

 

[Brianwarnock]

Does right click work for you? It doesn't seem to be an option in Access 2007

I'm slowly becoming no use to anybody as being retired I've no intention of getting and learning the vagaries of 2007.

Brian

 

[ankrumc]

nope, but it was right at the top in the ribbon. In design view, query tools, design, query setup