I wish to do two things. First, I want to set up a field in File1 that is automatically formatted like a telephone number such that, if one type in the number 2125551212 it will look like (212) 555-1212.

Second, I would like to import a file of telephone numbers into a separate file (File2), which are formatted as digits only (i.e. 2125551212), and then find any of the corresponding phone numbers on File1.

Thanks,

The Mad Jammer

And then...there was nothing

OK.

Calc for phone number

"(" & Left(Phone Number,3) & ") " & Middle(Phone Number, 4, 3) & "-" & Right(Phone Number, 4)

Now, as to the match data from second database to main database, create a relationship from the second to first using the phone number fields( Lets call it PhoneRelationship).

Then, you can create a calc that is

If (IsValid(PhoneRelationship::PhoneNumber), 1, 0)

Then you will know which numbers exist.

Muchas Gracias mi amigo.

The Mad Jammer

And then...there was nothing