difficult problem

  • Thread starter Thread starter fedum
  • Start date Start date
F

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, 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.
 
Where is the "calculated field total price" or whatever that you want to sum
in the report footer? I expect that you need to set a running sum on
payments in the payment header but you haven't provided enough information
regarding your fields.
 
I should have asked which section contains your payment. Is this in the
Payment group or the TicketID group?
 
Well Duane in the Payment Group.
Marc.
-----Original Message-----
I should have asked which section contains your payment. Is this in the
Payment group or the TicketID group?

--
Duane Hookom
MS Access MVP





.
Click to expand...
 
I expect that you need to set a running sum on payments in the payment
header.
Name: txtPmtRunSum
Control Source: [PmtField]
Running Sum: Over All (?)
Visible: No
Then in the report footer add a text box
Control Source: =txtPmtRunSum
 
Thanks Duane this is working.
Marc
-----Original Message-----
I expect that you need to set a running sum on payments in the payment
header.
Name: txtPmtRunSum
Control Source: [PmtField]
Running Sum: Over All (?)
Visible: No
Then in the report footer add a text box
Control Source: =txtPmtRunSum

--
Duane Hookom
MS Access MVP
--

Well Duane in the Payment Group.
Marc.
payment.
Is this in the
Click to expand...


.
Click to expand...
 
Back
Top