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 2k
Have 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.


Reply to this topic