Subreport Question

[BillyL]

I have a report in which I inserted a subreport. The main report, rptContacts is a list of contact information. The subreport, rptFundsSub, is a list of funds in which the contacts are part of. A particular contact can be part of several funds. I have a relationship between the two tabbles that drive the queries which the report is pased on. I also have a form with a subform similar to my report which works fine.

Here is what I want the report to show: Each contact will be listed once with all of their funds listed along with their informatin. For example, John Does record with list his informatin and also Fund1, Fund2 and Fund3.

Here is the problem: Any contact that is part of more than one fund has their record repeated on the report as many times as there are funds in which they belong. The records are displayed correctly (the contact info and the list of funds) but it is repeated for each fund. It is as if the fund subform is driving the record inclusion rather than the contacts.

I hope this makes sense and I appreciate any help.

Thanks!

 

[Qaroven]

Does it appear correct (ie no duplicates) in the underlying query, when you run that? Ben
+61 403 395 052

 

[BillyL]

No, the query reflects what appears in the report. I have tried to modify the join type but with not luck. It seems that there must be a way to show only one occurance of each record in the query even though there are duplicate records. What do you think?

Bill

 

[Qaroven]

What the query look like?
You may simply be able to group by/distinct the fields of the table producing the duplicates. Ben
+61 403 395 052

 

[BillyL]

You are right. I used the DISTINCTROW property of the query and it worked great.

Thanks!