Summing Fileds is a form

  • Thread starter Thread starter James New
  • Start date Start date
J

James New

I am trying to add some fields in a form as the user types
in the data, but I am not having much luck with this
 
Perhaps try putting the unbound textbox in the form's
footer, and then using the Sum function

=sum([FieldName])
(Assuming this is a number of course)
 
Assuming that the user enters data which you want to summarize after each
entry is made, and the summary result appears in a textbox, the control used
for entry should REQUERY the control where the summary is displayed, using
the entry control's after_update event. You can use this for a running
total.
 
Back
Top