need to search phone numbers

  • Thread starter Thread starter Rob
  • Start date Start date
R

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?
 
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/
 
Back
Top