Report in Access help

[ping99]

Hello,

I have an access table with 4 fields:

BusUnit group amount overlimit

Corp.A AAA 2000
Corp.A AAA 4000 100

Corp.B BBB 6000
Corp.B BBB 8000 200

to produce a final report like this :

Corp.A AAA 2000
Corp.A AAA 4000

Total Group 6000
Limit Group 100

Corp.B BBB 6000
Corp.B BBB 8000

Total Group 14000
Limit Group 200

It seems to produce a total group for each GROUP BY group field and put a limit group after.

Any help in producing this report in ACCESS or suggestions
would be appreciated very much

Thank in advance
Ping

 

[Zion7]

From design view, look into the Sorting & grouping dialog box.
Also text boxes have a sum property under the data tab.
you can use an unbound textbox, to aggregate your groups....