Access Report Problem

[Mike]

I have a report that is called from a form. I can noarrow the report to
the correct data, however I receive two sets of detail sections. I beleive
this because I have a payment table that records payments which is tied to
the underlieing query for the report. If I put in multipul payments
from the same person, example check payment and cash payment (split payment
part cash part check), into the payments table it doubles the detail
section on the report. It shows the detail once for the cash payment and
again for the check payment.

How do I get the report to show the detail only once? I am adding the
totals from the payment table on the report. It is basically a receipt for
the buyer.

Thanks in advance!

Michael Charney
mbcharney at sbcglobal dot net

[bruce]

Hello Michael,

If I am understanding you correctly you want to show total payments per
whatever it is that the buyer is paying for ("orders", perhaps). If
that is the case then open your report in design view then click on
View, Sorting and Grouping from the Access menu. In the Sorting and
Grouping dialog, add a field that you want to total payments for
(whatever field identifies your orders, let's say "OrderID" for
example). For the OrderID group, set 'Group Header' to No, 'Group
Footer' to Yes and 'Group On' to 'Each value'. This will create a
footer that will appear on your report each time the OrderID changes.
Now let's say your payment amount field is called PaymentAmt. Add a
text box to that footer on your report. Set its Control Source to
"=Sum([PaymentAmt])". This will display the total of payment amounts
for each OrderID. Finally, set the 'Visible' property of your Detail
section to 'No' so you don't see each individual payment for each
OrderID.

This is only one approach; you could also modify the record source for
your report to use a totals query which groups by OrderID and sums up
the payments for each OrderID.

Hope this helps somewhat.
Bruce