Running total on a form

[papapapa]

Access 97.

I'm new at this so bear with me.

On my form, there is are, among others, 3 fields (forget the quotes):

"Profit_To_Date"
"Profit".
"Shipping_Profit".

I want "Profit_To_Date" to derive its value from "Profit" (which includes "Shipping_Profit"), and to be updated on each record.

Repeat:
"Profit_To_Date" is the total of "Profit" and "Shipping_Profit".

"Profit" is a calculated field.

Can someone kindly help me with this and give an example?

The simpler, the better.

Thank You.

 

[Corticus]

Hi papapapa,

I usually use the DSUM function. MS has a good write-up here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q210495

Hope this helps,

 

[papapapa]

Thanks for the link. I tooked a good look at it. It's over my head.
Is there a rather simple way to accomplish the task, maybe with an example?

Thanks.

 

[Corticus]

The MS article is pretty straighforward, it just involves adding a control with a calculated field to your form, I'm aware of no easier way. The only other method I've seen used a UDF, and it wasn't very effective (referenced in the above article).

What part is over your head, do you know how to build a query? You're going to have to do that. Given the breadth of information on this subject, without a specific request, its discussion is not warranted.

As promised, your example is here:
www.theillumni.com/cort/runningSum.zip

Hope this helps,