Report based on query will show multiple values

[Indep99]

Hi,
I have linked two tables together in a query that has one primary key (file #) and then a bunch of information (first name, last name, date of birth) then a second table (file # --> which is linked, status --> which are multiple)
so these two tables are linked and the data comes out fine but the file # will be duplicated when there are multiple status... now when I create a report I don't want to see the file # duplicated so I set it as a header, but then the first name, last name, dob, etc get duplicated for each status... I would like to have file #, fname, lname, dob, etc listed once and then all the status listed for that specific row...

Thanks

 

[Mile-O]

Perhaps you want a Crosstab query feeding the report. Can't quite visualise what you are after.

 

[vbaInet]

From what I understand you can base a subreport on the second table and link it to the main report via file #. Don't link both tables in the main report, use the subreport to display the related status'.

 

[Indep99]

Thank you, I think the sub report is what I was trying to describe, I'll read into that more!