Update query question help please

[TotallyConfused]

I need some help with an update query please.

Name field consists of 3 letters (BBC)
control number consists of 3 Letters and 5 numbers (BBC12345)

I want to update some control numbers by changing the first 3 letters to
read CBB and leave the numbers alone.

How do I do this? Thank you in advance for any help you can provide.

 

[KARL DEWEY]

Use Replace function.
Replace([Name], "BBC", "CBB")

You will need to establish some criteria so that only the records you want
to change will be affected.

Using 'Name' as the name of a field is not good.

 

[TotallyConfused]

This worked!! Thank you very much. Have a great day!!

Use Replace function.
Replace([Name], "BBC", "CBB")

You will need to establish some criteria so that only the records you want
to change will be affected.

Using 'Name' as the name of a field is not good.

--
KARL DEWEY
Build a little - Test a little

I need some help with an update query please.

Name field consists of 3 letters (BBC)
control number consists of 3 Letters and 5 numbers (BBC12345)

I want to update some control numbers by changing the first 3 letters to
read CBB and leave the numbers alone.

How do I do this? Thank you in advance for any help you can provide.