Calculating Values in listbox (1 Viewer)

faz88

Registered User.
Local time
Today, 09:48
Joined
Mar 31, 2008
Messages
34
I have a listbox with details of items and prices, how do i go about calculating all the prices within the listbox?
 

missinglinq

AWF VIP
Local time
Today, 04:48
Joined
Jun 20, 2003
Messages
6,420
A Listbox, like a Combobox, is intended to be used as a selection device, not as a primary data display device. As such, it doesn't have the functions available to it to do this kind of thing, as a Continuous or Datasheet Form would have. To do this, I think you'd have to do it in the query that you're using as the Row Source for your Listbox.

But I'm curious as to why you have to calculate the price for an item. In the normal scheme of things, An Item would have A Price, which would be displayed in the Listbox. Do items have more than one price? What kind of calculation do you need to do?
 
Last edited:

Users who are viewing this thread

Top Bottom