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
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