SUM multi fields of a record

jasminewhite

Registered User.
Local time
Today, 05:09
Joined
Dec 8, 2011
Messages
26
How do I add a total of values in multi fields of a record?

My dream query result:

field1 field2 field3 total
1 1 1 3 (how?)
2 2 2 6 (how?)
TOT: 3 3 3 9 (how?)-this is grand total

Please help me sleep well tonight by giving me the syntax in a SELECT statement for my query.
Thank you in advance :p
 
In design view of the query, in a new field:

Total: Field1 + Field2 + Field3
 
Thank you, it worked. I can sleep well tonight.
 
Perhaps I've misunderstood the OP :o but perhaps the Sum function of a Totals Query is what is needed here?

This would give the total of all records for Field1, all records of Field 2 etc. Whilst Paul's solution provides the sum of fields 1, & 3 for each record. But as I said perhaps I have the stick by the wrong end :eek:
 
Last edited:
No, you're correct, that was part of the question. I meant to add that I would just do the totals on the form or report. To include them in the same query is possible, but typically not necessary.
 

Users who are viewing this thread

Back
Top Bottom