Adding a new control source to a report- How?

[benzo1]

I have an access report. It is generated from several control sources from a single table.

I want to add another control source from another table. But I can't find the option to do this.

Can anyone suggest a solution to this very basic problem?

Thanks.

Tanya.

 

[CosmoKramer]

Create a query that has the appropriate fields you currently have on the report.

Add the new table and link the related field(s).

Change the record source of your report to be the new query, instead of the table.

Add the new field from the second table to your report.