Link to home
Start Free TrialLog in
Avatar of ShotgunGaper
ShotgunGaper

asked on

How do i create a form to search an access table by person first name and/or last name, random keyword search for any related, phone number..

I have a small client database where id like to have a form with form search fields below that brings a list of search results.

- Search Name (Searches first name, last name or part of name returning ph, email , comapny name results)
- Search Keyword ( Any part of a name or phone number that brings up any related results)
-  Reverse Phone Lookup (Can search by part of phone number or full number returning results of first name, last name, company, email.)


I have yet to setup any queries yet...Just have main contacts table with lookup to company name. thanks

ASKER CERTIFIED SOLUTION
Avatar of danishani
danishani
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial