Sum the one of the list box column.

[Sigh]

Hi,
I have a Form include list box with the two columns and
the Text box on the form for the sum of one of the list
box's column. On the List box, One is Date Column and the
other is Amount column. How can I show the sum of the
Column Amount from the list box on the Text Box.

Any help would be very appreciated.

 

[Steve Schapel]

Sigh,

One possibility here, is that you are using a listbox where you would
be better to use a subform. If you have a listbox, I think the
simplest way to display the sum of one of its columns on the form is
to use a domain aggregate function referring back to the listbox's
rowsource query. Like this...
=DSum("[Amount]","NameOfYourQuery")

- Steve Schapel, Microsoft Access MVP