Search Database for value?

[Guest]

I would like to add a Find / Search function to my application, but was
wondering how I would go about doing this. Would this be a Select Statement?
How can I tell the Select Statement to return any row that contains the text
in one of it's cells.

For example, if I search "Dav", I would want to return all results that
began with Dav, such as David, Dave, Davey, etc...

Thank you.

 

[Guest]

In a normalized database you would be looking for a data item in only one
field, such as First_Name and not the whole database (An exception might be
where you are looking for a date due or completion date.).
In the design view you would use this as criteria --
Like [Enter start of name] & "*"

To search more than one field copy the criteria and paste in a different row
for each field to be searched.

To find matching data anywhere in the field use --
Like "*" & [Enter search data] & "*"