Rolling Total in Form

[foxtrot]

I want to add a rolling total to my form - i.e in my sub-form my margin per transaction is calculated - i want to total these transations on the form in order for my salesperson to see a rolling total for the day - i.e transaction 1 = $100, transaction 2 = $50 then TOTAL = $150 BUT I ONLY WANT HIM TO SEE THE TOTAL, the transactions are available in the sub-form - THIS MUST BE FOR THE SPECIFIC DATE (DAY) - how would i go about this one?

[NoellaG]

Hi,

you can put an unbound field on the head form and calculate the total there using a DSum function.

grNG

[foxtrot]

Hi, anybody who can help me?