Counting Gear in Each Platoon

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am in the Navy and I am trying to generate a report to save me the time of
transfering all the same info on to Excel. I want the report to list the
Name of each weapon in a platoon or team and the sum of the in each platoon.
Example:
Name "plt a" "plt b" "plt c" total
Pistol 16 17 7 40
Rifle 12 13 5 30
a-bomb 1 0 3 4
 
Could you provide the table structure or should we guess? How about some
sample records?
 
You need the following tables:
TblPlatoon
PlatoonID
PlatnoonName

TblWeapon
WeaponID
WeaponName

TblPlatoonWeapons
PlatoonWeaponID
PlatoonID
WeaponID
QtyOfWeapon

Create a query that includes all three tables and pull down PlatoonName,
WeaponName and QtyOfWeapon. Convert the query to a crosstab query and make
PlatoonName the Column values, WeaponName the Row values and QtyOfWeapon the
Value values.
 
Back
Top