Help with "or" statement

[tommy_mo]

I'm sure this is an easy thing to do, but I can't seem to get it to work the way I want.

The scenario:

I have a combo box "study" on my form that contains values eg. LAM, ZAP, HAM ect.

I have a table that contains 12 fields that may contain any combination of the "study" values or may be null. Each field only contains one value.

I have a query that is supposed to get all of the records that contain the study chosen on the form regardles of the field it's in. The problem is that I can't figure out how to set the "or" statement without running out of space in the query criteria. It seems that there is only room for 9 "or" criteria. Is there another way to get this done? Any and all help is welcome. Cheers. -Tom

 

[pbaldy]

I would wonder about the design, as it doesn't sound normalized, but you can switch to SQL view and manually add the needed fields.