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

Chapter 13. Locating and Managing Data w... > Modifying a Query in Design View

Modifying a Query in Design View

Once you have completed a query, you can further customize it in Design view. However, you can also create a query in Design view without using the wizard. Queries are not limited to a single table. Your queries can encompass multiple tables as long as the database includes a field or fields that relate the tables to each other. You can create a query using specific criteria and sort the results. If you no longer want to include a table or field, you can remove it from the query. In some cases you might want to hide a field from the query results while keeping it part of the query design for selection design purposes.

Modify a Query in Design View

In the Database window, click Queries on the Objects bar.

Click the query you want to modify, and then click the Design button.

Double-click or drag each field you want to include in the query from the field list.

In the design grid, enter any search criteria in the Criteria box.

Click the list arrow in the Sort box, and then specify a sort order.

To hide a field, clear the Show check box.

To delete a field, select the field, and then press Delete.

Click the Save button on the Query Design toolbar.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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