Editing Queries and Rerunning Reports

Rerunning queries regenerates the report; any changes to the original report, such as zooming, comments, and formulas are lost. Formatting is also lost.

You can refresh reports, but this only refreshes the data. It does not rerun the report.

To edit a query and rerun a report:

1. Open the Query Designer query sheet to edit. If the query sheet is hidden, from the data source ribbon, select Query and then Query Designer.
2. Edit the query.
3. Select Query then Run the Report.

   The report is updated.