Help ASAP. Please.

[shariefoo]

Hi,
I have a table with over 15,000 records. The ID is like the following formate. S123456

Unfortunatly i forgot to add the "S" and now i have over 15,000 IDs with no "S" at the begining.

I was wondering if there is a way where i can automatically update the field.

Thank you very much.

 

[neileg]

Provided your ID field is not an autonumber, and you really just need to add the 'S' on the front, then use an udpdate query. The help in Access is OK on how to do this, but post back if you have a problem.

If your ID field is an autonumber, there are ways around this. Post back.

 

[shariefoo]

Ohh no its not an auto number.
Thanx i will try the update query right now.

 

[shariefoo]

I am really sorry to bother you..

but when i create an update query and i enter all the fields and then i am faced with the "update to" field.

What do i put in there ?

 

[Mile-O]

"S" & [MyField]

where MyField is the name of your ID field.

Ensure, also, that it it set to text as if your field is numerical it won't accept this.

 

[shariefoo]

THANK YOU VERY VERY MUCH..

Thank you all who answered my help call..

THANKS YOU ALL