[AccessD] update query - question#1

KathrynAtGwens kathrynatgwens at socal.rr.com
Mon Jul 19 14:39:41 CDT 2004


Hmm, after I sent the first time, I realized I was on no-mail, so this might not have gone through. Sorry if it's a duplicate.

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) 




More information about the AccessD mailing list