Hey there…
This is probably terribly simple, but I cannot seem to find the correct syntax…
Got a table, lots of entries with different labels, and a couple of integer fields for each. I can easily get the total of 1 of the fields for each label with the SUM(field1) GROUP BY label syntax.
What I would like to do is get the total for both of the fields. I tried a few variations:
SUM (field1, field2)
SUM (field1 + field2)
SUM (field1) + SUM(field2)
but nothing has worked yet…
Little help, please?
Thanks