report working with sections

[fedum]

Report with group sections. First section is a header from the field PAYMENT (cash, visa, mastercard ….) then a second header from the field TICKETID and next DETAILS. In these details are sales with the pieces, price, reduction for each articles that has been sold on this ticket.
My problem: I would like to make the sum for each payment from the calculated field total price(in section details), reduction in the report footer. But when I have more then one article on the ticket than the sum reduction will be made for as much sales on each ticket. Ex. I have 3 articles on 1 ticket with only for 1 articles a reduction, well he takes this reduction 3 times. Also when I make a sub report.

 

[dhookom]

This phrase "make the sum for each payment from the calculated field total price(in section details)" makes very little sense to me. I assume you want to total the payments with unique values in the Payment header and then subtract calculations from the detail section.

You can create a running sum on the payment field in the payment header. Name the text box "txtPmtRunSum". In the report footer, you can reference txtPmtRunSum which will contain the sum of the values of all payments.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.