Searching for multiple records

  • Thread starter Thread starter JHM WINE
  • Start date Start date
J

JHM WINE

Will someone kindly point me in the right direction.
I have a database storing details of documents. The fields relevant to this
enquiry are Name, Matter and Xref (Cross reference). I wish to search the
database for records matching the input of part of a name (in which case there
would also be a search of the cross references based on the same input) or on
part of a matter. Ideally, it would be possible to input for both name and
matter and the search would take both into account. The results of the search
should then appear in a table.
Is this a case for filtering? Should the result appear in a subform?
 
Will someone kindly point me in the right direction.
I have a database storing details of documents. The fields relevant to this
enquiry are Name, Matter and Xref (Cross reference). I wish to search the
database for records matching the input of part of a name (in which case there
would also be a search of the cross references based on the same input) or on
part of a matter. Ideally, it would be possible to input for both name and
matter and the search would take both into account. The results of the search
should then appear in a table.
Is this a case for filtering? Should the result appear in a subform?
Click to expand...

It's a case for a Query. Create a Query based on your table with

LIKE "*" & [Enter search term:] & "*"

under the Name and Matter fields, and under XRef if you want to search
all three fields. Put the three criteria on *separate* lines in the
query grid so it will use OR logic. You can base a Form or a Subform
on this query for onscreen display.

It is neither necessary nor appropriate to store the results in a
Table.

John W. Vinson[MVP]
 
Back
Top