KathrynAtGwens
kathrynatgwens at socal.rr.com
Mon Jul 19 14:32:48 CDT 2004
I have a table named tblCemeteries4Updating The pertinant fields are: Name Surname FirstName MarrName Query #1 Name currently has (for example) WESTWATER, John Ovenstone I want to update this table to put Westwater (initial letter cap only, rest smalls) into the Surname field and John Ovenstone in the FirstName field. I know I have to first make a query with the fields in it, and then change it to an update query. That gives me the grid boxes for "Update To" and "Criteria" but I'm not sure what to type in them. After that is done, I have another update, but I think I'll do one at a time. Maybe with the answer to this one, I might be able to figure out the other one, though the other one involves two tables, so I might be back. -- Kathryn Bassett (at work address) kathrynatgwens at socal.rr.com kathryn at bassett.net (home)