ACCESS query column based on other value in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
Use the left function to grab the first three characters.

Field: Area: Left(PhoneNumber,3)
 
Back
Top