How do I change the data in an entire field?

  • Thread starter Thread starter Iwilfix
  • Start date Start date
I

Iwilfix

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.
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.
Click to expand...

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.
 
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.
 
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.
Click to expand...

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?
Click to expand...

Sure. Add the field first; run the update query as above.
 
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.
 
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.
Click to expand...

Glad to be of assistance, Jeff! That's why we're all here.
 
Back
Top