Sum of Listbox Column

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

Guest

I have a listbox with 3 columns and I want to place a control that adds all
the values in the 3rd column of the listbox. I tried something like this but
I get #Error:

=SUM(Val(listboxname.column(2)))

How can I do this? Thanks.
ck
 
I have a listbox with 3 columns and I want to place a control that adds all
the values in the 3rd column of the listbox. I tried something like this but
I get #Error:

=SUM(Val(listboxname.column(2)))

How can I do this? Thanks.
ck
Click to expand...

Is the Listbox based on a table, or on a query? or is it a "list of
values"?

If the former, use the DSum() function to sum the values *from the
table*. Bear in mind that a listbox is a *data display tool*; it's not
designed or intended as a repository for the storage of data.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top