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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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]
 
Back
Top