S
steve
I have a form that will pull contact information from a query that I built.
The query will pull items such as first name, last name, company working
for, etc. Is there a way to create a query that will search for the first
character of each word in a table field and then return that field as a
match to the search (i.e. If I have a company name saved as Advanced
Business Solutions in the "company" field of my table, is there a way to
create a query that will allow the user to search for ABS and return
Advanced Business Solutions as a result)?
The query will pull items such as first name, last name, company working
for, etc. Is there a way to create a query that will search for the first
character of each word in a table field and then return that field as a
match to the search (i.e. If I have a company name saved as Advanced
Business Solutions in the "company" field of my table, is there a way to
create a query that will allow the user to search for ABS and return
Advanced Business Solutions as a result)?