DWUTKA at marlow.com
DWUTKA at marlow.com
Tue Jul 20 17:54:19 CDT 2004
Okay, glad to help. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of KathrynAtGwens Sent: Tuesday, July 20, 2004 3:30 PM To: Access Developers discussion and problem solving Subject: RE: [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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com