Count Number Of Records

[Noelie2000]

I have a large personnel database in Access XP and have produced a query which groups by Regiment and then lists in rank order.

What I would like to do is count the number of records in each rank, which then either needs to be listed below each rank or as a list at the end of the report. Example report output that I would like below:

RLC

WO2 Bloggs
Cpl Other
LCpl Smith
LCpl Bloggs

WO2 = 1
Cpl = 1
LCpl = 2

REME

WO1 Bloggs
Sgt Other
Pte Smith
Pte Bloggs

WO1 = 1
Sgt = 1
Pte = 2


I would be grateful for any help. Simple solution that I can probably just not see.

Thanks very much,

Noel

 

[mark curtis]

have a look at attached example

 

[Noelie2000]

Thanks after a bit of tinkering that worked quite well.

Much appreciated.