Set up Field in Access Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field setup to enter pounds in a field per defect. I would like to
set up another empty field for the total acumative pounds in 1 field.
How do I set up an acumative sum of all records in one field.
 
I have a field setup to enter pounds in a field per defect. I would like to
set up another empty field for the total acumative pounds in 1 field.
How do I set up an acumative sum of all records in one field.
Click to expand...

Set the textbox's Control Source to some expression like

=DSum("[PoundsPerDefect]", "[tablename]", "<optional criteria>")

to dynamically sum the values. This calculated field should NOT be
stored in any table - there's far too much risk that it (or one of the
underlying fields) could be edited, making the stored value incorrect.

John W. Vinson[MVP]
 
Back
Top