subtotal on form

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

Guest

Hi: I am using Access for my first database creation. My form is complete.
What I would like to do is create a textbox that would show the running total
of a particular set of records on update of the record textbox. I have found
directions for a DSUM statement, but I don't really understand it. Would
someone please direct me through the process?

Thank you, Beth
 
Does the form have a records source? Assuming it is a table, and the field
from the table (which I will call MyTable) for which you need a sum is
MyNumber, you could put an unbound text box into the form footer. The text
box's record source would be =Sum([MyNumber]). You could also do something
like =DSum("[MyNumber]","MyTable") to return the sum of all of the MyNumber
values in MyTable. There are other approaches, depending on you specific
needs. It all depends on the details of what you need to do, and what you
mean by "a particular set of records".
 
Back
Top