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
- 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.