N
NDNobbs
I have a report. It has a list of employees. Each employee has an identifier
that is 2 letters (i.e., YB, YE, GS, WG, etc.). Each can be used multiple
times. Each employee also has a grade that is 2 numbers (i.e., 04, 05, 10,
13, etc.). A combination of these (i.e., YB 03) corresponds to a payband. For
example...YB 03 connects with band 1, YE 12 connects with band 4, YB 06
connects with band 4, etc. Multiple combinations of 2-letter identifiers and
2-digit grade numbers are possible. In a report, how can I pull the number of
employees based on their identifiers and connect it to the correct band to
get a total?
that is 2 letters (i.e., YB, YE, GS, WG, etc.). Each can be used multiple
times. Each employee also has a grade that is 2 numbers (i.e., 04, 05, 10,
13, etc.). A combination of these (i.e., YB 03) corresponds to a payband. For
example...YB 03 connects with band 1, YE 12 connects with band 4, YB 06
connects with band 4, etc. Multiple combinations of 2-letter identifiers and
2-digit grade numbers are possible. In a report, how can I pull the number of
employees based on their identifiers and connect it to the correct band to
get a total?