Im relatively new to Access 2007 and have a quick question.

I have 100K names and addresses in a table

In table 2 I have US Senators associated with a state code that is linked to the state code in the first table.

In table 3 I have US Representavies associated with a Rep Code (i.e CA3 would be District 3 California). This code is also in the table 1 of names.

What I would like to do is export table 1 out with the appropriate Senators and Representative associated with the name and address in an additional fields (SEN1 SEN2 REP)?

Any help?

Firstly Welcome to the forum.

assuming your data is correctly Normalised (http://en.wikipedia.org/wiki/Database_normalization) you should be able to do what you want using a query.