Telephone number search Area code (STD)

[ellegon]

I am new and i apologise dont have much knowledge in Access so any info / assitance will be greatly apreciated

What i am trying to do is i have a list of area codes connected to other data

What i want to do is do a search on a telephone number and this will check against the area codes and diaplay the required info

Example

Area info1 info2
01234 ab cd
012345 ar mc
01235 fg tr


So if I put a number like 01234567890 in the search box the result it will show is 012345 ar mc as this si the closet match to the telephone number.

I did it in excel with
=INDEX(whatwouldbedisplayed,MATCH(searchinfo,rowofdata,1))

Im not to sure if this can be done as a query so would it have to be a macro?

 

[Mihail]

From your example, the "Area" is not a fixed length string. Is it ?
Yes. Should be easy doable under Access.
Upload the DB with some samples. (Access 2007 or, better, 2003)

 

[jdraw]

Access (database) is very different than Excel(spreadsheet).

Here is a link to some underlying design concepts/principles for database.
http://forums.aspfree.com/attachment.php?attachmentid=4712&d=1201055452

(It appears the site is down at the moment) 8:26 AM 28/10/2013