i have this list and the values that start with "NT" do not get counted.
and this is what they wanted originally and i had on the report.
now they want another column with letters assigned to all of the entries.
how would i deal with these letters? i am assuming it will involve ASCI characters but i never know how long the list will be and could possibly go into double letters(though it would not be monstrously long - the longest i see so far goes up to "U")
A_______NT#####
B___1___B####
C___2___A####
D_______NT#####
E___3___B####
thanks.
and this is what they wanted originally and i had on the report.
now they want another column with letters assigned to all of the entries.
how would i deal with these letters? i am assuming it will involve ASCI characters but i never know how long the list will be and could possibly go into double letters(though it would not be monstrously long - the longest i see so far goes up to "U")
A_______NT#####
B___1___B####
C___2___A####
D_______NT#####
E___3___B####
thanks.