How to update or change a text field

Hello,
My problem is
1. How to update the text field. For example: the value of this field is 014(Text: data type) change to 425 (Text Data type also)
2. This happens all the time because of changing staff code in office-How to code it so that I just use one query to change this when it happens and do not have to make another query for this.
Thank you in Advance,
Le Tran

On Wed, 19 May 2004 08:46:04 -0700, "Le Tran"
wrote:

Hello,
My problem is
1. How to update the text field. For example: the value of this field is 014(Text: data type) change to 425 (Text Data type also)
2. This happens all the time because of changing staff code in office-How to code it so that I just use one query to change this when it happens and do not have to make another query for this.
Thank you in Advance,
Le Tran

A Parameter Query can do this for you.

Create a new Query based on the table. Change it to an Update query
(using the Query menu option or the query type icon).

On the Critera line type

[Enter code to be changed:]

and on the Update To line type

[Enter new value for code:]

or any other suitable prompts. When you run the query, the user will
be prompted twice; when the query runs, it will replace the value they
enter in the "to be changed" prompt with the value they put into the
"new value" prompt.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Hello John,

Thank you for your suggestion and I did it works fine, but now I need to do something that can tell the users that how many records that belong to this code (person) is changed to another code. I think that I need to code for this but I do not know how to or where to begin. Could you give some suggestion that would help!
Thank you,
Le Tran