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

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
 
K

Ken Snell [MVP]

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);
 
Top