Search results

I want to be able to assign value to a field based on first letter of Surname & first letter of firstname & three numbers. i.e. Fullname = Smith, Mary Helen Field = SM123 The following code only gets the first letter of the fullname & three numbers. Can anyone help me to fix this. Dim m1 As...