Combining Records From Multiple Tables...

[roystreet]

Hello,
...I have 2 tables that contain data for projects.
table1: tbl_MasterProj
table2: tbl_ProjModel

They are related by UniLMN -aka Project Number.

There is only one record per project in the master proj table. There can be multiple records per project in the proj model table. The proj model table contains models that are involved in the project.

What I need is to be able to generate a report that contains one entry for the project & list all of the models related to that project. Right now I can make a report that shows this, but each record shows the same project fields from the 1st table per every record in the models table. I hope I'm clear on this one.
Thanks,
~roystreet

 

[PWise]

1)look @ sub Reports

2) look @ HideDuplicates Property

 

[dhookom]

I would create a group header on the UniLMN field and put the project fields in this section.

Duane
Hook'D on Access
MS Access MVP