need to search phone numbers

[Rob]

I need to search a table that has phone numbers but it has a mask like
(000) 000-0000
Basically I want to search for a phone number but I'm not sure if I have the
wrong area code or what so I need to search for a partial number somehow.
Any ideas?

 

[Jeff Boyce]

Rob

Use a query.

In the criterion "cell" under the [PhoneNumber] field, put something like:

Like * & [Enter your search value] & *

This will prompt the user to enter a search string, then search the
[PhoneNumber] field for that string in any portion of the full phone number
field.

Add as many other fields as you need to the query.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Rob]

Thanks, that did it.