• 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 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:

1.
Open a new query and add the tables required for your query.

2.
Double-click the field list title bar of the table for which you want to include all fields. This selects all of the fields in the field list.

3.
Click and drag a field name to the Query Design grid's Field cell, and drop the field name where you want the first field to appear. Figure 10.39 shows an example of the result of the preceding steps for the Customers table.

Figure 10.39. Adding all fields of the Customers table to a query by double-clicking the header of the Customers field list and dragging the fields to the Query Design grid.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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