Simple Report in Access 2007

[George35]

This question pertains to a “Simple Report” made from a Crosstab Query and saved. Everything seems to work fine, except that if I modify the database in such a way that a field is added or deleted from the Query, the saved report when opened either fails to pick up the added field, or comes up with an error message saying it does not recognize the deleted field. To get a correct report, I have to make a new “Simple Report” from the updated Query. Is there a way to fix this problem? I am using Access 2007.
Thanks for any help.

 

[cookiegary01]

You do not need to create a new report.
Just add the new field in the report. Or delete the field from your report that is removed from your query..
The report is based on the query, so field names should be the same in your report.
Go to Report design view, and make adjustments.

 

[George35]

Thanks for the response.
I was hoping there would be a setting whereby the saved report would automatically pick up everything from the updated query results, including the updated (list of) fields.
I just want to make sure that I am not missing some easy step that everyone else is aware of.
Thanks again.