Totals in forms

  • Thread starter Thread starter Bill Davis
  • Start date Start date
B

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
 
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
 
Back
Top