Building an expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text field with numbers in it, in this field I wish to add two zeros
to beginnig of each record in the field. For instance, if the old field
record was "105", I would like to update the new field to record read 00105.
I would like to do this for all of the records in the field. Can anybody help
me build an expression?
 
By "each record in the field" do you actually mean "each record in the
table"? You also mention "old field" and then "update the new field". Are
you wishing to update the old field to the new value or update a
different/new field based on the value of the old field?

This might be a simple as a query with sql like:

UPDATE tblWithNoNameGiven
SET [Old Field] = "00" & [Old Field];

I always recommend backing up your database file prior to performing mass
updates.
 
Back
Top