thetank
Board Regular
- Joined
- Mar 17, 2005
- Messages
- 142
I am in the military and I need to keep track of how many people we have in our unit (over 500). They want to know how many of each rating we have and what pay grade they are in.
Example
BU1 Smith is an Builder (BU) and is an E6
BUC Nelson is a Builder (BU) and is an E7
BUCN Schmukatelli is a Builder (BU) and is an E3
EO3 Deere is an Equipment Operator (EO) and is an E4
We also have other ratings other than BU, EO etc.. that would fall into an other category, but they still want to know how many of each.
Basically I need to know how many E1's, E2's, E3's, etc we have: how many BU3's, BU2's, BU1's etc. we have, and then how many E5 and above we have in each category as well as overall.
I have gotten a majority of it figured out but I am having trouble getting the program to recognize the difference between say a ABFSN (Aviation Boatswains Mate E3) and an ABF1 (Aviation Boatswains Mate E6).
Thanks in advance
Example
BU1 Smith is an Builder (BU) and is an E6
BUC Nelson is a Builder (BU) and is an E7
BUCN Schmukatelli is a Builder (BU) and is an E3
EO3 Deere is an Equipment Operator (EO) and is an E4
We also have other ratings other than BU, EO etc.. that would fall into an other category, but they still want to know how many of each.
Basically I need to know how many E1's, E2's, E3's, etc we have: how many BU3's, BU2's, BU1's etc. we have, and then how many E5 and above we have in each category as well as overall.
I have gotten a majority of it figured out but I am having trouble getting the program to recognize the difference between say a ABFSN (Aviation Boatswains Mate E3) and an ABF1 (Aviation Boatswains Mate E6).
Thanks in advance