How to sum a column values in a list?

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

Guest

I have a list in a form that changes due to user control filters, I would
like to know if anyone know who to sum a column from that list, but only sums
what i see in the list, this would be equivalent to summing with the user
control filters. Thus the sum would be different for every filter. I have
tried the DSUM method in Control Source but is doesnt seem to work for some
reason. The Filters are time filters, and they are always "Between Date1 and
Date2". Thanks
 
In the footer of the form create a textbox and use this for the source --

=Sum([YourColumnFieldName])
 
Back
Top