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