Refreshing Report Fields 1

[spruceni]

I built a query and tested it.
I built a report based on the query and tested it.
I decided to add another field to the report so I added a new field to the query.
I tested the query and the new field was correctly output.
I then opened the report and clicked on the field list icon. The report is still looking at the old version of the query.

How do I get the report to pick up the new version of the query with the additional field in it.

Thanks for any help.

 

[Remou]

Check the Record Source property of the report. It is probably set to an SQL string, rather than the name of the query. You can either eidt the string or change the record source to the name of the query.

 

[spruceni]

Thanks for that