Count Number Of Records

Noelie2000

New member
Local time
Today, 01:45
Joined
Jul 16, 2003
Messages
6
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
 
Thanks after a bit of tinkering that worked quite well.

Much appreciated.
 

Users who are viewing this thread

Back
Top Bottom