Hi,
Here is a one way you could do this.
step 1
add a new field to the existing table.
step 2
scan the table and enter the Quantity * Price to that new field each record.
step 3
Now you can do the Sum() SQL statement on that new field.
Here is a another way you could try, but I am not sure.
Where you do the SQL statement, try this.
SELECT ALL SUM(qtyFld * PriceFld) FROM employee INTO ....
Any way the first option will work. If you could do the second option it will be better.
Good luck