Totalling Listbox Values (Access2K/Win2K)

Topic

New Reply

Not sure if this is possible…

Listbox on a form.. Two columns.. OrderdID and ShippingCost

Reply | Quote

Replies

You could, I suppose, cycle thru the rows of the listbox and add-up the values for that one column. But it would probably be easier to just use the DSum function as the controlsource for the textbox, using the same criteria you used for the listbox.

Reply | Quote

DSUM did the job perfectly…

I’m trying to do a count of the rows in the same listbox.. I’m tring to use DCOUNT but i think i am not referencing the listbox correctly??

Reply | Quote

Counting the number of rows is simpler: set the control source of a text box to

=[NameOfListBox].

substituting the actual name of the list box.

Reply | Quote

Counting the number of rows is simpler: set the control source of a text box to

=[NameOfListBox].

substituting the actual name of the list box.

Reply | Quote

DSUM did the job perfectly…

I’m trying to do a count of the rows in the same listbox.. I’m tring to use DCOUNT but i think i am not referencing the listbox correctly??

Reply | Quote