General Query Search

  • Thread starter Thread starter Shari
  • Start date Start date
S

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?
 
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
 
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
..
 
There are about 15 fields, that I need to search individually.
The customer name should be in a designated field, not scattered in 15.
 
Back
Top