I MEAN: Can I move some data in one field to another field?

  • Thread starter Thread starter Matt Meserve
  • Start date Start date
M

Matt Meserve

If I have the following data in a single field:

Denver CO 80210

Can I create a query or process that will move the zip code to a separate
field?

Thanks!
Matt
 
Sure... use an update query (after you create the field for the zip code):

UPDATE Tablename
SET ZipField = Mid([FullAddressField], InStrRev([FullAddressField], " ") +
1),
FullAddressField = Left([FullAddressField], InStrRev([FullAddressField], "
") - 1);
 
Back
Top