Forums
This topic is locked
Grouping - related fields under
Posted 19 Feb 2002 16:41:24
1
has voted
19 Feb 2002 16:41:24 Stuart Chase posted:
Access 2kHave tblScores.
Fields
ID,Callsign,Date,Mission,Score,Kills,Death
related tblPilots
Fields
Callsign,Squad,etc.
I want to group by squad first then under show all the individual pilots who have that squad in their information - with their related sums.
For example
Squad AAAAA 79 16 14
Callsign Month Score Kills Death
PilotA - February 02, 43 10 2
PilotB February 02, 24 5 3
PilotC February 02, 12 1 9
Squad BBBBB 99 54 20
PilotD February 02, 55 34 5
PilotE February 02, 33 20 5
PilotF February 02 11 0 10
And so on.
I can query by squad to get the sum of fields for the month but then when I try to put callsign in and repeat, it tries to repeat squad info for every pilot.
Any help would be greatly appreciated.