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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

readbess - 30 May 2005 17:59 GMT

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.

Reply to this Message

John Vinson - 30 May 2005 19:00 GMT

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

Reply to this Message