About computing a total for a calculated control on a form or report

When computing a total with an aggregate function such as Sum or a domain aggregate function such as DSum, you can't use the name of a calculated control in the Sum function. You must repeat the expression in the calculated control. For example:

=Sum([Quantity]*[UnitPrice])

However, if you have a calculated field in an underlying query, for example,

=ExtendedPrice: [Quantity]*[UnitPrice]

you can use the name of that field in the Sum function, as shown here:

=Sum([ExtendedPrice])

Notes  

• For information about creating a calculated field in a query in a Microsoft Access database (.mdb), click .
  
  
• For information about creating a calculated field in a query in a Microsoft Access project (.adp), click .
  
  
• For more information about the Sum function, click .
  
  
• For more information about the DSum function, click .