[AccessD] update query - question#1

That did it, thanks. I'll work on the next part and post any problems another time.

Kathryn

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