If your name data is stored in a single field, then you should consider separating it into first
and last name fields (and possibly other fields such as title, surname, middlename, etc.). A
great utility for doing this in called Splitter for Microsoft Access:
http://www.infoplan.com.au/splitter/
This utility can automatically correct the case at the same time that it splits name data.
You can also use an update query with the StrConv function:
Field: YourFieldName
Table: YourTableName
Update To: StrConv([YourFieldName],3)
However, you'll still need to do some manual correction for certain names. For example, the last
name MCMULLIN will be updated to Mcmullin, instead of the correct form, which is McMullin.
Splitter for Microsoft Access is pretty good about handling this type of situation without
requiring a lot of manual intervention.
Tom
___________________________________
I have a table with names all in upper case. What is automated way to make
all the records proper case?
Can it be done with an update query?
tia,
