Calculate and store macro

[ZOYA]

I have a total fee field and an administrative fee field. I want to create a
macro that will calculate these two fields and put the result in a total
field, by record. Can someone help me? Also, please let me know where I put
all the code and what not - I am self taught.

 

[Jeff Boyce]

It sounds like you are trying to store these values. It is rarely necessary
(nor desirable) to store values you can calculate.

For one thing, if any of the underlying values are changed (e.g., correcting
a typo), the stored "calculated" value would not be updated unless you ALSO
build this capability in.

For another, retrieving a stored value (?from disk) takes considerably
longer than re-calculating it from the underlying fields.

Consider using a query to retrieve the underlying fields and to calculate
the "fee" fields you described. Consider NOT storing those fee values, but
only displaying them in a form.

Regards

Jeff Boyce
Microsoft Office/Access MVP