Apache OpenOffice Community Forum

This must be a simple query, but after reading through many posts on the topic I can't get it to work.
I have a table called payslips with columns including payslip_id, tax and net_pay. I want to calculate the totals for tax and net pay. I select sum in the function box for the tax field but running the query gives me SUM("tax") 0.
Please help?

Ciao, please compare your database with mine.

Thank you Charlie, your help is much appreciated. You make it look so simple, which I'm sure it should be. I set up a database like yours, ran a sum query and got the results as shown on the screenshots attached. Can you make sense of it?
Mike

The difference is that charlie.it has used decimal fields (numeric) whereas you have used text fields (string).

Hooray, that was it!
Thank you David and Charlie.it.