Hi Everyone,
I'm a first time poster but long time lurker. This is a great site!
I am an novice access user and I am having trouble with trying to set up a query where if a last name starts with "Mc".... it will capitalize the next character. For example: Mcdonald would change to McDonald...