Can a calculation be posted to a database?

I have a total calcualtion on my report and need to post that back to my
database so I can total that number for my month end numbers. Currently I
have the total text box in my report footer and I create about 100 of these
reports a month.

The ability or need to store a calculated value should have nothing to do
with a report. Normally you don't store values that can be calculated. If you
can't live without store this type of value, use code or queries to calculate
and store the value. This should never depend on a report.

--
Duane Hookom
Microsoft Access MVP


"****ry" wrote:

I have a total calcualtion on my report and need to post that back to my
database so I can total that number for my month end numbers. Currently I
have the total text box in my report footer and I create about 100 of these
reports a month.

"Duane Hookom" wrote

The ability or need to store a calculated value should
have nothing to do with a report. Normally you don't
store values that can be calculated. If you can't live
without store this type of value, use code or queries
to calculate and store the value. This should never
depend on a report.

If, for example, there is a need to store a
"this-is-the-value-that-was-reported", the VBA code to store that value or
execute the query to store that value, can be executed in the Print event of
the Section of the Report in which that calculation is displayed.

Larry Linson
Microsoft Office Access MVP



__________ Information from ESET Smart Security, version of virus signature database 4049 (20090501) __________

The message was checked by ESET Smart Security.

http://www.eset.com