creating access reports with multiple tables

[scissorsmc]

Hey all,
I am attempting to create an access report. I have 19 tables built by client. In each of these tables i have a list of names, (last name, first name) with the last name as my primary key, and other information. i would like the report to list the name and the clients that they belong to. unfortunately i cannot get the report to do as i like. anyone have any suggestions???

Thanks,
scissorsmc

 

[CautionMP]

Have you tried the Microsoft: Access Reports forum?

Funny thing about being unemployed, weekends don't mean quite so much, just means you get to hang out with your working friends. Primus

 

[scissorsmc]

Thanks, I couldn't find that group before so office seemed like the next best choice.

 

[fneily]

First, never use Last Name as a primary key. How do you reconcile John Smith, Joe Smith? If all your tables contain First Name and Last Name, then you probably didn't NORMALIZED your tables. Extremely bad. You would then create the necessary RELATIONSHIPs between the tables. You then bring the tables together in a QUERY to make a single output. Then you use the Report Wizard with the query as input. It sounds like you need about a month's worth of Access courses.