multiple operation query

A

AccessDummy

I am new to sql. I want to design a query where I can sum the value of
fields multiplied by each other. AKA Total VatCOSt = SUM of vatrate
unitcost for a specified form number.

Any ideas how I would do this
 
M

Michel Walsh

Hi,



SELECT ItemID, SUM(qty *unitcost)
FROM somewhere
GROUP BY ItemID




Hoping it may help,
Vanderghast, Access MVP
 
Top