I have a make table query in Access 2007 that has a city field that is in all caps. I want to convert the city to lower case, but I want the first letter of each word in the city to be capitolized. Is this possible in the expression builder? If I use LowerCity: LCase([B5CZTX]), all words in the city are lower case.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Select Query in Access 2007
- Thread starter TracyB250
- Start date
- Status
Similar threads
