Search Phone Number - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Search Phone Number

David Clement

16 months ago

I have created a Customer contact Database. My Phone Number search is Set up like this inside a query:
"*"Like"*" with the appropriate other criteria.
It only works if I enter all 10 Digits like this: xxxxxxxxxx. It will bring back any number that I am searching for just fine if it is the database. It wont look for partial numbers, such as area code, xxx.I thought using the Like in the query criteria, it wouldnt matter if all 10 digits are entered or not.
What did I do wrong?
Thank you.

	Kevin Robertson @Reply 16 months ago
"with the appropriate other criteria" - this information could be helpful. The wildcard characters should be after the Like keyword. Example `Like "" & [Forms]![MainMenuF]![PhoneSearch] & ""`

	David Clement OP @Reply 16 months ago
I'm sorry, i didn't think I would need to do that here. I have set that in the criteria already. As I said, it works great, but only if I enter all 10 digits. Thank you.

	David Clement OP @Reply 16 months ago
I have around 15 records in my CustomerT table. When I use my search form, it will find the record if and only if I enter all 10 digits like this, xxxxxxxxxx, just like I have set in my table. iF i enter it like this, xxx (area code) xxx (Prefix) or xxxx (Last Four) it wont find anything. All 10, it's works just fine.

	Sami Shamma @Reply 16 months ago
David, Please send a screenshot of your query in design view

	Bill Carver @Reply 16 months ago
One possibility is that you should only store the value of xxxxxxxxxx with no formatting and as a short text string. not as a number. The sami's example will work. You'll need to name the fields accordingly Like "" & [Forms]![NameOfYourForm]![NameOfYourPhoneSearchField] & ""

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View