SUM function ??

[prodtest]

Hi
I have a text box on a form which needs to be populated with the SQL statement below:

SELECT SUM(costprice * (ukuntested + uktested + ukbonded + ukfaulty + ukavailloan + ukgoodsonloan + uktestkit + uksupplierreturns + usuntested + ustested + usbonded + usfaulty + usavailloan + uste + usatsupp + usloan + ausuntested + austested + ausbonded + ausfaulty + ausavailloan + ausloan))FROM productcat

How can I make this happen, been pulling my hair out !!

Thanks all

Ben

 

[Remou]

You need DSum.