Stuart McLachlan
stuart at lexacorp.com.pg
Wed Feb 26 00:56:31 CST 2014
Update tblHistories
Set StateProvince = STRCONV(StateProvince,3),
County = STRCONV(County,3),
Town = STRCONV(Town,3)
On 25 Feb 2014 at 20:49, Kathryn Bassett wrote:
> On to another. Googling gets me some answers for Excel, but not
> Access.
>
> https://www.dropbox.com/s/c5cg7uji1kkhr0i/ConnerBishopHistoriesPlay.ac
> cdb
>
> In the Histories table, I converted the Country field using
> Find/Replace. But I don't relish the time required to do that with
> StateProvince, County, and Town. Is there a quick way to change those
> to first letter upper case, rest lower case?
>
> For instance NOVA SCOTIA to Nova Scotia, SAINT JEAN to Saint Jean,
> CLARKE COUNTY to Clarke County?
>
> --
> Kathryn Rhinehart Bassett (Pasadena CA)
> "Genealogy is my bag" "GH is my soap"
> kathryn at bassett.net
> http://bassett.net
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>