The
condition we just added (LIKE '%8%') is not meant to find anyone, because in an
exercise in Chapter 12, we changed the phone number of all authors with name
'Smith' to '444-5555'.
If we want another criterion on the same column, we just add a criteria row.
The Multi-Table Query Generator
[ 214 ]
Adjusting the Number of Criteria Rows
The number of criteria rows can be changed in two ways. First, we can select the Ins
checkbox under Criteria to add one criteria row (after clicking on Update Query):
As this checkbox can only add one criteria row at a time, we'll uncheck it and use
instead the Add/Delete Criteria Row dialog. Here, we choose to add two rows:
Another click on the Update Query button produces the following:
Chapter 13
[ 215 ]
We can also remove criteria rows. This can be done by choosing negative numbers in
the Add/Delete Criteria Row dialog or by ticking the Del checkbox beside the rows
we want to remove. Let's remove the two rows we just added because we don't need
them now:
The Update Query button refreshes the page with the specified adjustment.
Adjusting the Number of Criteria Columns
We can add or delete columns by using a similar mechanism: the Ins or Del
checkboxes under each column, or the Add/Delete Field Columns dialog. We
already had one unused column (not shown on the previous images to save space).
Pages:
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205