Firstly, sorry if this is posted in the wrong area. I am just a n00b. Literally my first post, and my 1st access project.
I am building an inventory list for my business and I am trying to generate a unique 'ItemID' field.
I want to get only the uppercase letters from my BandName field and a...