Sum of Each Field

[flygal5]

Need help with my query. I have 4 fields - Q1 Q2 Q3 Q4. I'd like to be able
to have fields of totals for each quarter. I've tried going to each field -
View (on Menu), then TOTAL (replaced Group By with SUM) but it just replaces
the field name. I'd like to be able to have the existing fields and then new
fields with the sum of all the quarters. Thanks for any help. Flygal5

 

[Marshall Barton]

Need help with my query. I have 4 fields - Q1 Q2 Q3 Q4. I'd like to be able
to have fields of totals for each quarter. I've tried going to each field -
View (on Menu), then TOTAL (replaced Group By with SUM) but it just replaces
the field name. I'd like to be able to have the existing fields and then new
fields with the sum of all the quarters.

From you explanation above, I can't tell what you want. If
you have other fields in the query, then I think you should
try using the DSum function:
SELECT f1, f2, ...,
DSum("Q1", "yourquery") As TotQ1,
DSum("Q2", "yourquery") As TotQ2,
DSum("Q3", "yourquery") As TotQ3,
DSum("Q4", "yourquery") As TotQ4,
FROM youruery