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

Chapter 16. Creating Queries from Scratch > Adding Fields to a Query

Adding Fields to a Query

Whether you create your query from scratch or modify an existing query, the Query Design view provides the capability to add the table fields that will be contained in the query. Be sure that the tables that contain the fields for the query are present in the design window.

Adding More Tables You can add tables to your query at any time. Click the Show Table button on the toolbar, or select Query, Show Table. Then, select the tables you want and click Add. Click Close to return to your query design.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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