I have a listbox that can have anywhere from 1 entry to probably 20 entries at a time. Its for a quoting database.. Each quote can have multiple line items.. This list shows the line items.. IE: Trucking / Ocean Freight / Customs Clearance etc..
The list has columns - ID / Description of Line Item / Cost / Sell
I have three text boxes above that.. I need to calculate the totals into those textboxes. What is the easiest and most efficient way to do this.. remember they are in currency. Is there a dsum or do i have to create a loop ???
The list has columns - ID / Description of Line Item / Cost / Sell
I have three text boxes above that.. I need to calculate the totals into those textboxes. What is the easiest and most efficient way to do this.. remember they are in currency. Is there a dsum or do i have to create a loop ???