D diagostj Registered User. Local time Today, 01:02 Joined Aug 12, 2003 Messages 20 Nov 17, 2003 #1 I have a pre-existing table that includes city, state, and zip all in one field. Is it possible to separate it into three fields?
I have a pre-existing table that includes city, state, and zip all in one field. Is it possible to separate it into three fields?
IgorB Registered User. Local time Today, 06:02 Joined Jun 4, 2003 Messages 183 Nov 17, 2003 #2 Update a new field for city using function InStr Update ZIP field using InStrRev