Listbox Question

[mshelley1]

Access2000

Greetings:
I have a list box on a form that gets its data from a query; one of the columns contains a number value. I have a textbox, also on the form, which needs to display the sum of the numbers in the list box column. Is that possible?

The listbox name= list8
textbox name= total

Thanks

 

[Rickster57]

query

Place a textbox in the detail section of your form corresponding to that number field from the query. Name it MyNumberField
In the footer section of that form place a textbox with it's source set to :
=sum([mynumberfield])