Using 'Or@ Criterion

M

Mick Humph

If you wish to design a query which contains say 24
separate fields in which you wish to return a result from
12 of the fields which are "True" and exclude the other
12 fields. It requires you to place "True" in each of
the 12 colums on a separate Row in the Design Grid.
However there are only 8 Rows on the Design Grid. What
should you do?
 
M

MikeC

Mick,

You can insert additional rows as follows:

1) Put your cursor in the row where you want to insert a new row.

2) Select "Rows" from the "Insert" menu.

3) Repeat as many times as needed.
 
J

John Spencer (MVP)

Another Way of doing this is to reverse the boolean test and use an IN clause.

In an empty column, enter the following - replacing the field names with your
fieldnames (and the brackets are needed in Access).

Field: True
Table: <Blank>
Criteria: IN ([FieldA],[FieldB],[FieldC],...,[Field12])
 
Top