[AccessD] update query - question#1

Line wrap!

In the design view, it shows Trim(Mid([ and that's it.  In the SQL, go to
the end of that line, and hit delete, which should bring Name].... back up
into that line.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of KathrynAtGwens
Sent: Tuesday, July 20, 2004 11:56 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] update query - question#1


:( fooey, it didn't work. Asks me for a parameter value.
I copy/pasted your SQL statement:
http://www.babcockancestry.com/storage/accesscemeteries1.jpg
and went to the design view to look at how that parsed out
http://www.babcockancestry.com/storage/accesscemeteries2.jpg
then ran it and got this:
http://www.babcockancestry.com/storage/accesscemeteries3.jpg

On a side note, before I pasted the SQL statement, the default was
UPDATE tblCemeteries4Updating SET;
I tried adding the ; after SET in your statement but that gave a syntax
error, so I don't know what that is about.

Kathryn

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
> DWUTKA at marlow.com
> Sent: Monday, July 19, 2004 1:08 PM
> To: accessd at databaseadvisors.com
> Subject: RE: [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
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

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