Making All Fields of Tables Accessible
Most queries that you create include only the fields you specifically choose. To choose these fields, you either select them from or type them into the drop-down combo list in the Query Design grid's Field row, or you drag the field names from the field lists to the appropriate cells in the Field row. You can, however, include all fields of a table in a query. Access provides three methods, which are covered in the following sections.
Using the Field List Title Bar to Add All Fields of a Table
One way to include all fields of a table in a query is to use the field list title bar or asterisk. To use this method in your query to include all fields, together with their field name headers, follow these steps: ...
Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.