Add field from a different table to report

[swmatrixman2003]

I need to add one field to an existing report. The report is based on one table and the field I need is in another table. How can I add this new field?

 

[RV]

Base your report on a query instead.

RV

 

[Ziggy1]

the query would contain both tables and drag a join between related key fields. Delete the join between ID's that Access may put in if they are not related.

Experiment with the join type by double clicking on the lines (all choices should be same). The default join returns only records between tables that match. You may want it to return from one side and only matching from the other..

Ziggy