View Related Fields

The whole thing

When designing a query, you'll often find the need to temporarily view fields beyond the ones you want shown in the final result.

To do so, you probably drag the relevant fields to the design grid and then delete them when you're done. However, there's an easier way to view the data that you typically want excluded in the query.

To do so:

1. Open the query in Design view.
2. Display the query's Properties sheet
3. Set the Output All Fields property setting to Yes
4. Run the query

Data from all of the underlying tables' fields will be displayed in addition to the fields you specified in the QBE grid. To change the query so that it only displays the fields explicitly selected in the QBE grid, simply
reset the Output All Fields property to No.


 



See all Topics