[Access 2000]

When you are designing a query and you would like to temporaily view fields from the underlying tables beyond the ones you want shown in the final result. Do do this, most users drag the relevant fields to the design grid and then delete them when they're done. However, there is a much easier way to accomplish the same thing. Here's how:

1. Open the query in Design view.
2. If necessary, display the query's Properties sheet.
3. Set the Output All Fields property setting to Yes and 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 specifically selected in the QBE grid, simply reset the Output All Fields property to No.