Calculating Totals and subtotals

[sdc1234]

Greetings,

I have a query that calculates Totals, subtotals and grand Totals of 22 different teams....(I have them Ordered 1-28)

What I am having trouble with is the grand totals which I have <=24(Order 24 is the Total) in the query which only gives me the correct total for 1 column, I have 6 columns I need to get the grand total for

any help would be appreciated.

v/r
novice

[ItsMe]

Have you tried using the Totals tool while in Design View of a query object?