I've used an telephone number mask to enter area code and telephone numbers. I would now like to build a query to match an area code to a major city and related time zone. Any suggestions?
Will you have a table with the city and time zone and area code? If so,
just create a relationship that links the area code in your table with the
left three characters of your phone number.
Rick B
I've used an telephone number mask to enter area code and telephone numbers.
I would now like to build a query to match an area code to a major city and
related time zone. Any suggestions?