Subtotals

[kumar]

Div COSTCentre TOTAL
ABC 102 $1230
XYZ 106 $1000
ABC 100 $250
EFG 105 $350
ABC 102 $130
XYZ 106 $1200
ABC 100 $650
EFG 105 $450

I want to produce a report that should summarise data by DIV but sutotals by Cost centre ( ie a sub total for 102 = 1360)
please help

Kumar

 

[AccessUser]

Use this query as your record source in your report:
SELECT test1.Div, test1.CostCenter, Sum(test1.Total) AS SumOfTotal
FROM test1
GROUP BY test1.Div, test1.CostCenter;

Then select View->Sorting and Grouping
In the first line select Div

In the second line select CostCenter then under group properties make group footer Yes