Additional 'A' to existing data -- please help,Urgent !

[shiro]

Hi All,
I have around 19000 records in my table.And there
is a text field that I want to add a letter 'A' to the
end of existing data.I want to add to all of them,how
to do it quickly.Thank's.

Rgds,

Shiro.

 

[George]

Dear Shiro,

First make a backup of your database.
Then create the following query to update all of your records:

UPDATE Table1 SET Table1.yourfield = [Table1]![yourfield] & "A";

where Table1 is your table name and yourfield is the name of your field

Good luck

GeorgeCY

Ο χÏήστης "shiro" έγγÏαψε:

 

[shiro]

Many thank's Mr George,
I will try it.
Have a nice day.

Dear Shiro,

First make a backup of your database.
Then create the following query to update all of your records:

UPDATE Table1 SET Table1.yourfield = [Table1]![yourfield] & "A";

where Table1 is your table name and yourfield is the name of your field

Good luck

GeorgeCY

? ??????? "shiro" ???????:

Hi All,
I have around 19000 records in my table.And there
is a text field that I want to add a letter 'A' to the
end of existing data.I want to add to all of them,how
to do it quickly.Thank's.

Rgds,

Shiro.