Combining Two Tables

[Guest]

Hello, forgive me if this is an easy question...it's not for me!!!

I have two tables, primary members and secondary members. Primary table
contains all the information for the household. Secondary members contain
additional names and email addresses. I'm trying to create a report that
lists all the members from both tables, alpabetizes them, and then pulls the
address from the primary table to the secondary table on the report. This
will then populate the addresses on the report for secondary members. Does
this make sense?

Thanks!!!

 

[Marshall Barton]

I have two tables, primary members and secondary members. Primary table
contains all the information for the household. Secondary members contain
additional names and email addresses. I'm trying to create a report that
lists all the members from both tables, alpabetizes them, and then pulls the
address from the primary table to the secondary table on the report. This
will then populate the addresses on the report for secondary members. Does
this make sense?

You need to create a query that Joins the two tables. Then
you can add the address field to the query's field list
along with the other data.

That may not sufficient to get everything you want in the
report, so if you need additional assistance, post back with
details about the pertinate fields in both tables.