Create field that will return number based on characters before the dash
I am trying to modify a query in access. I have a field that has a certain number of letters, a space and then a dash. For example:
What I want to do is create a field that will return a one, two, three or four based on how many characters are before the space and the dash. For 'a -' I would want a 1 return. For 'aa -', a two, etc.