Counting Gear in Each Platoon

  • Thread starter armedtotheteeth
  • Start date
A

armedtotheteeth

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
 
D

Duane Hookom

Could you provide the table structure or should we guess? How about some
sample records?
 
P

PC Datasheet

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