 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / February 2004How do I change the data in an entire field?
I have a client mail list. Recently a large portion of it were assigned new zip codes. I was able to seperarte them,but do not know how to change them globaly. Don't want to do them 1 by 1 Could someone tell me how thanks. Jeff V. >I have a client mail list. Recently a large portion >of it were assigned new zip codes. [quoted text clipped - 4 lines] > > thanks. Jeff V. With an Update Query. Since you don't say how they will change or what the criteria are, I can't explicitly say how, but an Update query is the way to go. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public Basicly they are changed from 07753 to 07794 I only use a 5 number mask. I have not used, or do not know most of the access features. But I will engage the help window and see if I can learn what an update query is, and perhaps how to use it. as always, thank you for your reply. Oh. Could the update query also enter data in a new field added to a table? thanks again. Jeff V. >>I have a client mail list. Recently a large portion >>of it were assigned new zip codes. [quoted text clipped - 13 lines] > Come for live chats every Tuesday and Thursday >http://go.compuserve.com/msdevapps?loc=us&access=public >Basicly they are changed from 07753 to 07794 >I only use a 5 number mask. >I have not used, or do not know most of the access >features. But I will engage the help window and see if >I can learn what an update query is, and perhaps how >to use it. If you don't find it (and knowing how wretched the Access Help indexing is, that's a real possibility!) try this: - Create a Query based on your table - Select the Zip field (only) - On the Criteria line put "07753" (assuming that Zip is a Text field, as it should be - 7753 if it's numeric) - Change the query to an Update query, using either the query type icon in the toolbar, or the Query menu option - On the Update To row which appears, put "07794" under the field (or, again, 7794 if you're unwisely using a number datatype) - Click the ! icon to run the query. > as always, thank you for your reply. >Oh. Could the update query also enter data in a new field >added to a table? Sure. Add the field first; run the update query as above. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public Thank you for showing me how. sometimes 2 or 3 lines of input is so much easier then trying to locate it in the help files or the "bible" never mind the "for dummies" books. Again thanks Jeff. >>Basicly they are changed from 07753 to 07794 >>I only use a 5 number mask. [quoted text clipped - 34 lines] > Come for live chats every Tuesday and Thursday >http://go.compuserve.com/msdevapps?loc=us&access=public >Thank you for showing me how. sometimes >2 or 3 lines of input is so much easier then >trying to locate it in the help files or the "bible" >never mind the "for dummies" books. Glad to be of assistance, Jeff! That's why we're all here. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.