C
Chris Moore
I have a name & address table. The zip code is zip+4 data. I need to keep
that but I also need a zip that contains only the 1st 5 digits. I have
created a 2nd field called ZIP5 but how do Icopy the contents of zip+4 over
to ZIP5? I have 1,000,000+ records so it must be automated somehow (SQL,
macro, whatever).
Thanks
Chris
that but I also need a zip that contains only the 1st 5 digits. I have
created a 2nd field called ZIP5 but how do Icopy the contents of zip+4 over
to ZIP5? I have 1,000,000+ records so it must be automated somehow (SQL,
macro, whatever).
Thanks
Chris