So I have a table that has a corresponding number for each letter. I what the user to supply a text word - say 'MSACCESS'.
I would like for the query to scan the word and add up the following for the letter number assignment table (tblTEXTNUM) example
M = 1
S = 2
A = 3
C = 4
E = 5
so M + S + A + C + C +E +S + S or 1+2+3+4+4+5+2+2
equaling and returning the sum of 23 at the end
TIA
Stephen