If they're that consistent, you can use the Right() or Mid() functions. If the lengths could vary but the dashes always there, add InStrRev() to find the last dash.
The lengths of the entries do vary, but are consistent with the dashes. Would you mind showing me what this would look like by using an example from the snip of the table I posted? I am a new Access user, and not very keen on the specific things I need to put into the queries to have them operate properly.
Check out the InStrRev() and Mid() functions. Use the first in the starting position argument of the second.
I was speaking more towards using the query builder in Access...
Not coding
The functions can be used in a query.