SUM multi fields of a record

[jasminewhite]

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

 

[pbaldy]

In design view of the query, in a new field:

Total: Field1 + Field2 + Field3

 

[jasminewhite]

Thank you, it worked. I can sleep well tonight.

 

[pbaldy]

No problemo!

 

[John Big Booty]

Perhaps I've misunderstood the OP 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

 

[pbaldy]

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.

 

[jasminewhite]

Thank you, I appreciate all your tips