Using 'Or@ Criterion

  • Thread starter Thread starter Mick Humph
  • Start date Start date
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?
 
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.
 
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])
 
Back
Top