Need help updating records...PLZ HELP ASAP

  • Thread starter Thread starter Nadia
  • Start date Start date
N

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.
 
Use an Update Query. Assume your table is called Table1 and your field is
Field1, the statement would look like this:

UPDATE Table1 SET Table1.Field1 = "MH" & [field1];

In the query grid, add Table1 as the table, add Field1 in the field grid.
Change the query to an Update Query and add the following "MH" & [field1] to
the Update To: row.
 
Back
Top