Math function on output

[LordShryku]

I'm trying to do something that's probably real easy, but I'm kind of struggling. I'm doing a query against a database to pull a lot of records. It will usually pull out about 1000 records, each with a "quantity field" with an integer in it. I want to be able to get a grand total for for that field. Any ideas?

Thanks 😃

[barand]

select sum(quantity) from mytable where ....

hth

[LordShryku]

Works like a charm. Thanks a bunch 🙂