update query

[Erik]

I have a table with records for example S-001,S-002,S-003 and i want to
update them to add an extra 0 in the front. I would like it to show
S-0001,S-0002,S-0003. Is there any way to do and update query to add the 0?
Thanks.

 

[Tom Lake]

I have a table with records for example S-001,S-002,S-003 and i want to
update them to add an extra 0 in the front. I would like it to show
S-0001,S-0002,S-0003. Is there any way to do and update query to add the 0?
Thanks.

Create an Update Query and under the field to be updated (I'll call it MyField) use
this
in the Replace With row:

Left([MyField], 2) & "0" & Mid([MyField], 3)

where Myfield is the name of your field.

Tom Lake