Comparing two fields with identical input masks

[Kinger43]

I have a form control with the input mask on it for a phone number. I am using an append query to append the information entered in the form to a table. I need to pull two fields from a linked table from another database. What I need to do is be able to compare the entered phone number in the form with the phone number from the table. The problem I am running into is that it won't match the phone numbers. The same mask is used in the table I am pulling from. Why can I not just put =

.[Phone_No] in the Criteria of the field where the number from the form is placed so that I can get the right record from the linked table?

 

[Guus2005]

Why don't you compare the exact same mask in the query:

Where format([telno],"[##][####]") = format([othertelno],"[##][####]")

 

[Dennisk]

you should be able to compare like with like as an input mask is not stored as part of the data. All it does is to control how a user enters data. I would take a copy of both tables and remove the input mask and any formatting then do a visual comparison on the data.

 

[Kinger43]

Thanks for the suggestions but they still didn't work.
Is there some reason why it isn't recognizing the data is there?

 

[Kinger43]

When I removed the input mask from the form and just typed the phone number as a general number it ran fine. I guess I'll just have to deal with it.