calculation from a queried list

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

Guest

how can i calculate a total for a column in a list box, from a list
containing several columns, and apply the total to a text box on a form. is
there an axpression i can use in the text box w/o going to code? The list
box is requeried upon clicking items in another list box. how can the total
be requeried in the text box?
 
Use a DSum() expression in the Control Source of your text box, e.g.:
=DSum("Field1", "Table1")
Use the 3rd argument - the Where Condition - if needed.

If the text box does not update quickly enough, you can Recalc the form when
you Requery the listbox.
 
Back
Top