I'm a newbie and am sure this will be fairly easy. In an Access query, I want to parse out leading * in a record. For example:
*37643 Eliminate the five digits from the right leaving the *
**37643 Eliminate the five digits from the right leaving the **
37643 Eliminate the five digits from the right leaving (Null)
I've tried Right & Left and not getting it. Thanks for your help!