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

Chapter 6. Locating Specific Information... > Changing the Query Fields

Changing the Query Fields

In Design view, you can add or remove fields in your query design to produce different results. You can also include fields from other tables in your database. In some cases you might want to hide a field from the query results while keeping it part of the query design for selection criteria purposes. When you remove a field from the query design grid, you're only removing it from the query specifications. You're not deleting the field and its data from the underlying table. When you hide a field by clearing the Show check box, the field remains part of the query; it just won't be displayed to the user.

Add a Field to a Query

Display the query in Design view.

Double-click a field name from the field list to place the field in the next available column in the design grid, or drag a field to a specific column in the design grid.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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