I received this database originally in UPPER CASE letters. When I convered to lower case, with the 1st letter being UPPER CASE, everything worked fine except that all the MacDonalds, McIntyres and MacInnis came out as Macdonald, Mcintyre and Macinnis.
How do I fix this so that the 3rd or 4th letter is UPPER CASE.
peacock97
Last Activity: Jan 17 '10, 12:20 AM
Joined: Dec 9 '09
Location: New Brunswick
-
peacock97 started a topic Microsoft Access Database - I have a mailing list of approximately 41,000 names.in AccessMicrosoft Access Database - I have a mailing list of approximately 41,000 names.
-
Uppercase to lowercase
I have an access mailing list. I received it in UPPERCASE and have been able to change the 1st letter to UPPERCASE and the rest to lowercase except that in Proper Names like McDonald, McInnis, they come out as Mcdonald or Mcinnis. I have tried to modify my query to accommodate this; however, unsuccessfully. Here is my query, and wondering how I could change it to accommodate my problem:
UPDATE [All Councils] SET [All Councils].LastName...
No activity results to display