Adding field to field list in existing report

[sept20]

I have created an extensive report (by my standards) and after reviewing,
decided to add another field to the Excel spreadsheet that I linked to pull
the information. I cannot figure out how to get that new field and
associated data pulled into the report. Do I have to resort to creating an
entire new report? When I look at the help options it says to pull it from
the Field List. However, the field is not in the Field List because it
wasn't there when I initially created the report. Any suggestion?

 

[Duane Hookom]

Do you see the field in the linked spreadsheet in Access? You might need to
modify the SQL of your report's record source.

 

[sept20]

Yes, I can see the field on the linked spreadsheet opened through Access.
Given that, do you still think I will need to modify the SQL of the report's
record source. If so, can you give me some pointers on how to do that?

 

[Duane Hookom]

Open the report in design view. View the properties for the report and find
the Record Source property. Click the builder button to the right of this
property to modify the fields selected for display in your report.