Free E-Books

When you??™re adding multiple fields from several tables, you must add them
from one table at a time. The easiest way to do this is to select multiple fields and drag them
together down to the QBE grid.
You can select multiple contiguous fields by clicking the first field of the list and then clicking the
last field while holding down the Shift key. You can also select noncontiguous fields in the list by
holding down the Ctrl key while clicking individual fields with the mouse.
Selecting the * does have one drawback: You cannot specify criteria on the asterisk column
itself. You have to add an individual field from the table and enter the criterion. If
you add a field for a criterion (when using the *), the query displays the field twice??”once for the *
field and a second time for the criterion field. Therefore, you may want to deselect the Show cell of
the criterion field.
Understanding Multi-Table
Query Limitations
When you create a query with multiple tables, there are limits to which fields can be edited.


Pages:
435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459