I am trying to make a unique ID for each of my records. So in my "First Name" and "Last Name" fields, I am trying to ADD ALL of the characters' ASCII code in both fields. AN e.g
First Name : JOHN (string)
Last Name : DOE(string)
Member ID should be : (Ascii of J) + (Ascii of O) + (Ascii of H) and so on till (Ascii of E) (in Last Name).
The problem with this is that the asc(string) command, returns the value of only the 1st letter in the string.