Reporting the SUM - Guru definately needed!

Is there any way to make a report show the sum of all of the records in a recordset? For instance, I have a table with a field named ID and another field named balance. I would like to be able to say something like "Show me the sum of all of the records of the balance field in this recordset"...

Thanks for your help,

Squirrelly1

SELECT Sum(Price) AS TotalPrice

thankx

LOL wohh needed a huge tech head for that one, hahah

I am glad a GURU answered this one.

I did know how to do it , but no Guru here so no answer either.