Sum column in report

[hdesbiens]

Hi

i need help to do this:

i have an expense report that lists the expenses of a range of dates:

Field on my report in section detail:

date
idinvoice
client
subtotal
tps (calculated =([subtotal]*[databasetps]))
tvq (calculated =(([subtotal]+[databasetps])*[databasetvq]))
total (calculated =[subtotal]+[databasetps]+[databasetvq])

my formulas works on this part of the report but not in the footer where i want to put another calculation:

Footer of the report:

SumSubtotal = sum([subtotal]) (ok it works)
SumTps = sum([tps])
SumTvq = sum([tvq])
SumTotal = sum([total])

so that's my problem sumtps, sumtvq and sumtotal are blank and before the report generate it ask me those values???

is there a way to sum those calculated field on my footer report?

thanks a lot!

 

[dhookom]

You can't Sum() controls. You can sum expressions based on field like:
Sumtps: =Sum([subtotal]*[databasetps])
Sumtvq: =Sum(([subtotal]+[databasetps])*[databasetvq])
Sumtotal: =Sum([subtotal]+[databasetps]+[databasetvq])


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]