[AccessD] update query - question#1

UPDATE tblCemeteries4Updating SET
[Surname]=strConv(Left([Name],inStr([Name],",")-1),3),[FirstName]=Trim(Mid([
Name],InStr([Name],",")+1))

That should do it! (No other querries necessary)

Drew
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of KathrynAtGwens
Sent: Monday, July 19, 2004 2:33 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] update query - question#1


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) 

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com