Trying to total the quantiy and unit price

[MarySan1]

I am using access 97. In the design view of the query, I want to total the quantiy of product times the price per unit to get a total of the invoice. Can anyone help me with writting this expression?

 

[hmckillop]

SELECT SUM(QtyProduct * UnitCost) As TotalInvoice
FROM Orders --or from your invoice table
WHERE InvoiceID = ?


"Own only what you can carry with you; know language, know countries, know people. Let your memory be your travel bag.

 

[PHV]

TotalOfInvoice: Sum([quantiy of product] * [price per unit])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244