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

Part 6. Creating Queries > Adding a Field to a Query

Adding a Field to a Query

After you've displayed the query you want to modify in Design view, click the field you want to add in the field list and drag it to an empty column.

The field is added. Click the Save button on the Standard toolbar in the main Access window to save the query design.

Click the Run button to run the query.

Access runs the query and displays the results; the field you added (in this case, Artist Phone) is included. Click the Close button to close the query.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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