Totals in forms

[Bill Davis]

i have 3 field on my form that are used for totals. I
really dont need them to be on the form but I still need
a sum entered into the table for reporting. Where can I
place the formula to have it entered in the table?
Thank you

 

[Michel Walsh]

Hi,


If you need it only for a report, do NOT store it into the form... Once
stored, that sum would not be automatically updated anyhow when you change
any element making that sum. It is preferable to COMPUTE the SUM each time
you need it... in this case, when you print the record, make a

DSum("fieldOrExpression", "tableName")


as computed expression for your control ( in the report ).


Hoping it may help,
Vanderghast, Access MVP