School Help: DB Access question. - Zilvia.net Forums | Nissan 240SX (Silvia) and Z (Fairlady) Car Forum

jOeHaCk98 · 02-28-2006, 07:41 PM

These are the fields:
Firstname, Lastname, Order Date, Product name, Quantity, Unit Price, OrderID

Here is the problem
I want to total up the customer orders, right now it is displaying each individual order. I want to delete the duplicate 'OrderID' BUT merge the 'Unit Price' THEN multiply by the 'Quantity'

Can anyone help?

THANKS!

02-28-2006, 07:41 PM	#1
jOeHaCk98 Zilvia Addict Join Date: May 2002 Posts: 730 Trader Rating: (0) Feedback Score: 0 reviews	School Help: DB Access question. These are the fields: Firstname, Lastname, Order Date, Product name, Quantity, Unit Price, OrderID Here is the problem I want to total up the customer orders, right now it is displaying each individual order. I want to delete the duplicate 'OrderID' BUT merge the 'Unit Price' THEN multiply by the 'Quantity' Can anyone help? THANKS!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode