I want to calculate the sum of "price" in a orders table into a variable....

I tried this..

sSql = "select sum(price) into intPrice from orders where client = 007"

This does not work.

Can anyone please help!!??