Colin:
I know how you like to test different ways of doing things. I suspect you would like to compare the techniques offered in this thread.
Greg
I know how you like to test different ways of doing things. I suspect you would like to compare the techniques offered in this thread.
Solved - Access - Counting Letters and Numbers In A String
Good afternoon. I have some data like this: AB12 ABC1 ABC12 ABCD123EF I would like to count letters, numbers, and then letters again if applicable. This would give me: AB12 = 22 ABC1 = 31 ABC12 = 32 ABCD123EF = 432 I am not sure if this something I can do in a query using LEN along with...
www.access-programmers.co.uk