How can I show the total value of a database in a label?

Question

I have a database table called expenses. They are multiple columns such as food, gas, fuel etc all with numeric values. How can I generate the value of all the records added together and then to show the total in a label?

Thanks for any help!

SUM(yourField) is your friend – Bernd Buffen May 31 '16 at 19:36 — Bernd Buffen, May 31 '16 at 19:36

score 0 · Accepted Answer · answered May 31 '16 at 19:44

0

I think you mean letting the database perform the sum for you. If that's the case then a query like this should do:

SELECT Food + Gas + Fuel AS Costs FROM Expenses

Should you want the total cost for all records? Then use SUM:

SELECT SUM(Food + Gas + Fuel) AS TotalCosts FROM Expenses

answered May 31 '16 at 19:44

yazanpro

4,512
6
44
66

Thanks for your advice Yazan. I tried your query but it doesn't seem to add the total of the rows to the total_expenses row? – callum mikaelson May 31 '16 at 19:57
So you have total_expenses **column**? that wasn't mentioned in the question. Anyway, try this instead: `UPDATE Expenses SET total_expenses = Food + Gas + Fuel` Do a backup of your database before start manipulating with update commands. – yazanpro May 31 '16 at 20:06
This worked! Thank you @yazanpro, I appreciate it! – callum mikaelson May 31 '16 at 20:13
Sure. Glad to help. – yazanpro May 31 '16 at 20:30

How can I show the total value of a database in a label?

1 Answers1