S
Steve E
I am trying to add a column of information based on values already in another
column in the query. Specifically, I want to put a value in Column.AreaCode
based on the Leftmost 3 characters in Colunm.PhoneNumber -- basically I have
a list of contacts outputted by another database that does not isolate the
area code in its record set and I want to add my sales rep info that is based
on area code to this query.
I can do this in a heartbeat in EXCEL but I'm trying to migrate to a 'real'
database...
Working in ACCESS 2003 on WindowsXP OS
Thanks,
column in the query. Specifically, I want to put a value in Column.AreaCode
based on the Leftmost 3 characters in Colunm.PhoneNumber -- basically I have
a list of contacts outputted by another database that does not isolate the
area code in its record set and I want to add my sales rep info that is based
on area code to this query.
I can do this in a heartbeat in EXCEL but I'm trying to migrate to a 'real'
database...
Working in ACCESS 2003 on WindowsXP OS
Thanks,