Too many criteria selections needed (1 Viewer)

[myrock]

I have a query going against a Medical Survey table. I need to show anyone who is past due on any of 10 different date fields. My problem is the criteria selection box only has 9 lines for 'OR' selctions. Is there any way I can include the 10th field?

Thanks for your help.

Tom

 

[Jack Cowley]

In design view of the query select View > SQL and then using the preceding code as a guide add another Or operator and the rest of the code that you need.

 

[Jeanette]

You can write the 10th criteria in any one of the 9 lines as in the following example "BK02" Or "BX02". You can write several selections followed by Or on one line. I hope this helps.

 

[myrock]

Thanks to both of you. I was unaware of the SQL View, that was a winner.

Thanks again.

Tom