I am sure this has been done before...
I need to query a Clients table to identify, if a client exists by querying the phone number field. The phone numbers are stored in the table using the input mask:
!\(999") "000\-0000;0;_
How do I write the criteria in the query following the prompt: [Enter client phone number:]
?
The query succeeds only if I enter well formatted phone number e.g. (987) 654-3210.
I would prefer that the end-user type the phone number into a template, so he can type only the digits, without the need to type using the exact format.
Thanks for the help.