How to sum up the summary totals

[moi]

Dear all,

I created a report through the wizard and with summary of groups, now my problem is when I summed ( =Sum[tcp] )up the summary totals it gives me a wrong figures.. Pls i need help, what is the correct function, sum is not giving the correct figure..

 

[tvanstiphout]

Show us, because we all use Sum(FieldName) and it works for us.

 

[moi]

Show us, because we all use Sum(FieldName) and it works for us.

Yes I always use the Sum[fieldname], this is what puzzled me.. see attached

 

[tvanstiphout]

That formula looks good to me.
Now we have to turn to the data. Show us the data, and the resulting sum. Why is that wrong to you?

I'm assuming a sales report is run for a date range. What if you restrict to a single date? Still wrong?

 

[Gasman]

Where is txtTotalPayment coming from?

 

[moi]

That formula looks good to me.
Now we have to turn to the data. Show us the data, and the resulting sum. Why is that wrong to you?

I'm assuming a sales report is run for a date range. What if you restrict to a single date? Still wrong?

I will try that one.. this is were the report coming from..

 

[moi]

Where is txtTotalPayment coming from?

calculated field from a query..

 

[Gasman]

And where on the report is that control?

 

[moi]

That formula looks good to me.
Now we have to turn to the data. Show us the data, and the resulting sum. Why is that wrong to you?

I'm assuming a sales report is run for a date range. What if you restrict to a single date? Still wrong?

Only the page total i got wrong, i can not figure out where is the problem..

 

[moi]

That formula looks good to me.
Now we have to turn to the data. Show us the data, and the resulting sum. Why is that wrong to you?

I'm assuming a sales report is run for a date range. What if you restrict to a single date? Still wrong?

I compared the total to excel column total.

 

[Pat Hartman]

Functions in a report ALWAYS refer to column names from the recordsource, they do not refer to control names. So, if you have a control that adds three fields and you want to sum that value, you repeat the calculation.

=Sum(Nz(TotalPrice,0) + Nz(Tax,0) + Nz(Shipping,0))
NOT
=Sum(txtNet)

PS, if you have any potentially null values, you need to use Nz() to get rid of them when doing calculations.