Duplicate records printing

[Trudye]

Hey Guru’s I hope I am explaining this properly, anyway here goes:

I have multiple children records that can appear under the parent record. Although they print to two different reports they are each fed by queries based on a common key. The parent record prints on the first report and the children info prints on the second report.

The multiple children recs are causing the parent rec to print multiple times. For instance if the family has 2 children the parent report prints 2 identical pages of parent information. Is there a relatively easy fix for this?

I cannot think of a way to control the queries for just this report. I looked at properties but I saw nothing that will help. Outside of building the entire record from a module and we are talking approx. 123 fields. If I can avoid coding it I would like to do that. Also I have another report that has the same problem and it has approx. 87 fields.

If you have any idea please let me know.

Thanks so much
Trudye

 

[hpicken]

Check your joins in your query.

If you right clight on the join between tables in your query, you can nominate to include all parent records and only those child records to match or the other way around.

I use to fall for this one myself a few times.

Howard

 

[bev]

I may be wrong, but I don't think that's the issue since the parent *will* match with multiple children. I would think you could use the Distinct predicate (select distinct * from Parents) or use the First or Last function on the Parents' records to only pull one.
Bev

 

[Trudye]

Thanks to everyone for their input. I believe the problem is inherent to Access, I was hoping there was a way around the problem that I was not aware of. Maybe something new with 2k.

Thanks again
Trudye