Problem with Report from Query

[jmcarroll7]

I have created a report that pulls info from 2 queries. The first is based
on chemicals that were delivered and the second is from chemicals used (I am
working for a pool cleaning company). My problem occurs when there is only
one delivery and more than one instance of use. The report duplicates the
delivery entry every time there is a new useage entry. I have tried hiding
duplicates, but it still shows up in my totals.

 

[Duane Hookom]

Use one or more subreports. I expect you would see the issues if you review
your report's record source in datasheet view.

 

[jmcarroll7]

I now have to sub reports. One is based on the delieries query and the other
is based on the useage query.

Now, my question is, how do i keep the clients grouped together? In each
subreport I have them grouped by client and sorted in the same way, but some
clients have more useage entries and the alignment gets out of whack.

 

[Duane Hookom]

Set the Record Source of your main report to unique ClientIDs. Then set the
Link Master/Child properties of your subreports to the ClientID (or similar)
field.