Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
I need a MS Access Query that will seperate phone numbers by Time Zone?
I need a data base that has all the US area codes seperated by time zone. then I need to know how to tell my data base to seperate them.
1 Answer
- Anonymous1 decade agoFavorite Answer
Start with a web site that lists all the area codes and their time zones. There is one below, but there may be easier ones to use. Next, copy all the information into an Excel spreadsheet, save, then use the <Open> command in Access to turn the spreadsheet into a database. Finally in your query, link your existing table of numbers to the new table by area code, pull the time zone and sort by the time zone.
Source(s): http://www.softwaretools.com/ac-timezone.pdf