Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 25th, 2003, 08:43 PM
Authorized User
Join Date: Jun 2003
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to vickriz
Default Update query how to?

hi to all. i used access98 and have a table with 200,000records. i had a problem with one of the field within my table, and i realy need some help. i make a query for a newtable like this.

SELECT tblPoliticalPersonalities1.* INTO newTable
FROM tblPoliticalPersonalities1
WHERE (((tblPoliticalPersonalities1.NameSuffix) Like "Jr") AND ((tblPoliticalPersonalities1.FirstName) Like "*J"));

now, what i want to do is to trim or delete the last character "J/j" from my tablefield FirstName?

only i know is to make an update query. but i dont know how to play around with string from fieldnames.. any idea?
all help i will considerate..
thanks in advance..

Old August 26th, 2003, 09:44 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts


Run this update query on your new table:

UPDATE newTable SET FirstName =Left(FirstName, Len(FirstName) - 1)

That'll remove the final character from any data stored in your FirstName field.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Query Help dalezjc Classic ASP Basics 8 March 18th, 2008 08:49 AM
I solved insert query.now see this Update Query. [email protected] VB.NET 2002/2003 Basics 2 September 21st, 2006 12:48 AM
Update query trab Access 1 May 11th, 2006 03:58 PM
Please Help me about UPDATE query huyremy VB Databases Basics 8 September 29th, 2004 03:45 AM
Update query edcaru Access 3 June 14th, 2004 03:04 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.