Finding formatted data

[The Mad Jammer]

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

[andygaunt]

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.

[The Mad Jammer]

Muchas Gracias mi amigo.

The Mad Jammer

And then...there was nothing