How do I add a field to an existing Access report?

[Guest]

I have created an Access Report but discovered I needed to add an additional
field from a table. I cannot figure out how to add in the additional field. I
am using the Access 2000 version.

 

[John Vinson]

I have created an Access Report but discovered I needed to add an additional
field from a table. I cannot figure out how to add in the additional field. I
am using the Access 2000 version.

Open the Report in design view; view its Properties. Select the
"Record Source" property (first on the Data tab). Click the ... icon
to open a Query design window based on the report's query.

You should be able to add the field at this point. Close the design
window and accept Access' offer to save the SQL. The new field will
now be available in the report's field list.

John W. Vinson[MVP]