How do I insert additional data to a field?

[johngordon]

I have a field in a table that is named ID, it contains record numers from 1 to 2000.

I want to insert 03- into each record so the ID number will look like 03-000001 and so on.

I thought I could do this using find and replace, but it does not work. Anyone have any suggestions?

Thanks,

John

 

[jrbarnett]

Hi,

In order to store a leading zero and a hyphen the data type of the field must be text (rather than numeric).

If this is the case, then a simple Update query could do the job.

John

 

[cghoga]

John,

Change the format of the field within the table from number to text.

Run this line of SQL:

UPDATE YourTable SET YourTable.YourFieldName = "03-" & [YourFieldName]

or create an update query and make this your Update To: criteria ("03-" & [YourFieldName].

hope this helps you.