[RESOLVED] Adding field contents together

[kbc1]

Hi all

Hopefully just a simple one but im stuckk all the same.

I have a field in my table called quantity. For each record in the table the quantity field stores an integer value which can be anything from 1 to 99.

I need to run a function/query that adds these integer values together and returns the total number (i.e. select quantity from table, then add them up etc)

Can anyone help?
Thanks

[kbc1]

Thanks i sorted it.