Need help ASAP...have to edit data in records

[Nadia]

I have a list of over 7000 unique numbers (i.e. 123 or 77-
123). I need to add the letters "MH" in front of each
number. Is there an easier way to do this than to click
and edit each individual record manually? Please help,
anyone have any suggestions? Lots of thanks in advance.

 

[Charlie]

I have a list of over 7000 unique numbers (i.e. 123 or 77-
123). I need to add the letters "MH" in front of each
number. Is there an easier way to do this than to click
and edit each individual record manually? Please help,
anyone have any suggestions? Lots of thanks in advance.

You cauld use an update query. To avoid losing the data in your
original list, add another field and update to that field (say
Field2). Ex. If your data is in field1 and it's set up as text, then
the expression would be : "MH"+[Field1] placed in the update to: box
under Field2.

 

[Douglas J. Steele]

Use an Update query.

The syntax would be something like

UPDATE MyTable
SET MyField = "MH" & [MyField]

If you're doing this through the query builder, select the table, and drag
the field into the grid at the bottom. On the Query menu, select Update
Query. This will add a new row "Update To" under the field and table rows in
the grid. Type "MH" & [MyField] into the cell on the Update To row
underneath the field. (Change MyField to whatever your field is called)

This presupposes, of course, that the field is text, and not numeric!