totals problem

[Pampers]

Hi everyone,
I'm having trouble to calculate invoice totals. The invoice is grouped on BillingCompany,Vessel and CrewMember. The invoice looks like

BillingCompany1
VesselName1
CrewMember1
Amount 1a
Amount 1b
subTotal x
CrewMember2
Amount 2a
Amount 2b
subTotal y

TOTAL ??


...then the Invoice goes to the next BillingCompany with certain Vessel and so on. I want a total calculated for every invoice (where the questionsmarks are). But I can't get it to work, tried an extra query, tried to make a total in the vessel footer (running sum over group). No go. Any suggestions?






Pampers
Keeping it simple can be complicated

 

[rjoubert]

Your TOTAL field should be in your BillingCompany group footer. In the Control source of that field, try...

= Sum([AmountField])

Note: You don't need to set the RunningSum property.

 

[Pampers]

Hi rjoubert,
Tnx for the fast response. I agree, normally it would be there, but in this case the company gets a bill for every vessel they have. So, I putted in the VesselFooter, but no go.

The detail is a subform, where the subtotals are with the name SumInvoiceDetail, controlsource: [=Sum(nZ([ProcesInvoiceAmountUSD]))]. Now, I need a total of these SumInvoiceDetails for every vessel. Hope you can follow...


Pampers
Keeping it simple can be complicated

 

[Pampers]

Hi Rjoubert,
I raged myself, took a little walk, and created a total query instead, with CompanyID, VesselID and InvoiceRunID to bind to it down... Mmmhh. Works.

Pampers
Keeping it simple can be complicated