• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Creating Multitable and Cros... > Making All Fields of Tables Accessib...

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 dropdown 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 the following three methods for including all fields of a table in a query:

  • Double-click the field list title bar of the table to selects all of the fields in the field list and then drag the field list to the Query Design grid. Each field appears in a column of the grid.

  • Drag the asterisk (*) to a single Query Design grid column. To sort on or apply selection criteria to a field, drag the field to the Query Design grid and clear the Show check box for the field.

  • Set the Output All Fields property value in the Query Properties sheet to Yes to add with asterisks all fields of all tables to the grid.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint