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:
- Open the query in Design view.
- Display the query's Properties sheet
- Set the Output All Fields property setting to Yes
- Run the query
reset the Output All Fields property to No.
See all Topics