Doing a search in Access

T

Trenchardc

Hi. I have a database with one table and a form of this table. Is there a
moderately simple way so have a search for this. For example, in the
Northwind database, there is a query which asks you to input some data for it
to find results. Hope you understand what I mean! Basically, I want to be
able to search this form or table using some kind of input for one of the
fields. Thanks!
 
K

KARL DEWEY

Use this for query criteria --
[Enter your data for search]

or if you wish to search by putting in the first part --
Like [Enter your data for search] & "*"

or if you wish to search by putting in any part --
Like "*" & [Enter your data for search] & "*"
 
Top