Problem with SUM() on Access

  • Thread starter Thread starter Tanvir
  • Start date Start date
T

Tanvir

Hi,
I am working with a Access Database. In that Database I
have a table name Amount. There are 2 field [Amount],
[T_Amount]. I want to display sum of all the records of
[Amount] to [T_Amount]. Would anyone please solve this
problem
 
Can you be more specific? Do you have multiple records with an amount (say by Order number) and you want all those records to have the same total amount, or is it more like an amount times a quantity for a total amount per record?
 
You shouldn't store a calculated value because it will
change as you add/edit/delete your data.

If you need the total for a report, create a new text box
control, place it in the appropriate group header/footer
section, and set its control source property to:
=Sum([FieldName])

If you need the total for a form, do the same thing, only
use the DSum() function. See your help file. It'll look
something like:
=DSum("FieldName","TableName","WhereCondition")

Good luck.
 
Back
Top