Sum data from multiple item form

[swavemeisterg]

I have a multiple item form used to display items from an inventory.

What I need to do is sum a specific aspect of the entries. So say I filter my results to only show items with serial number 23-09. There will be multiple entries for that serial number, but they will all have different values for a “material removed” field.

What I want the form to do is display the sum of the displayed values.

Any ideas?

[June7]

Form is in Continuous or Datasheet View?

Continuous, try: textbox in form Header/Footer with expression of =Sum([material removed])

Datasheet, try: form not in design view, click the Totals button from ribbon to open a summary row at bottom of the form, select the Sum function under the "material removed" field.

[swavemeisterg]

It was continuous and that worked perfectly! Thanks!