General Query Search

[Shari]

I have a table with countless records of customers. There are about 15
fields, that I need to search individually. When needing to search for
customers, I need to be able to put in as little information as possible to
bring up their record. I have the queries set up for each field, but it will
not bring up the record based on the minimal amount of information. When
working for another company that had a database like this set up, we were
required to use astericks on either side of the information we were inputting
in the query field. What do I need to do in order to get this done?

 

[Michel Walsh]

Instead of using equality, =, you can use LIKE.


Open Northwind. Make a new query on table Customers. Drag the CompanyName
field in the grid. In the criteria line, type:

LIKE '*ick*"



That should return all companies name with the sequence ick in their name.
Only one is found in my version.




Hoping it may help,
Vanderghast, Access MVP

 

[John Spencer]

You will need to use the LIKE operator and wildcard characters.

Find something contained in the field (start, end, or middle)
Field: Some Field
Criteria: Like "*" & [Find what] & "*"

or starts with
Field: Some Field
Criteria: Like [Find what] & "*"

or if you wish to enter the wildcards yourself
Field: Some Field
Criteria: Like [Find what]

More than that I cannot tell you since I have no idea what your queries look
like or how you are entering the search.
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[KARL DEWEY]

There are about 15 fields, that I need to search individually.
The customer name should be in a designated field, not scattered in 15.