Hi People,

In one table (AllCalls) I have
Telephone Number : Short Text
Call Date : Short Date

In the other table (AreaCodes) I have
Code : Short Text
Area : Short Text


I am trying to create a query that produces a list:
Telephone Number, Call Date, Code, Area

The criteria should be something like:
If the Telephone Number begins and matches with Code (varies in length), then display it's Area, otherwise display "Not Found".

The Telephone number is the complete number, i.e. has the area code at the begining.
This is uk phone numbers, so differ in length.


Any help much appreicated.