Area Code queries

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

Guest

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?
 
A query, or a relationship?

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel "Local" phone numbers in a list do not include area code. How to add? 2
input mask for phone number 2
City/area code 3
Advanced Filter 5
Programing Telephone Numbers 2
city/area code outlook 2007 1
Telephone Numbers 2
How can I click on a telephone number in an Excel 2002 spreadsheet, and have the number dialed? 2

Back
Top