Looking for a way to make a Query or Find and Display multiple records using only part of field

[gdmoland]

I want to be able to enter only part of a field like in the Find
command, but I want to display all records that match the partial
field entry. Example: I want to find and display all records that
begin with 'sm' or 'a & b', because the database table has lengthy
entries in the fields. This is an old dBase IV table that was
extracted into Microsoft Access 2003.

Thanks

 

[KARL DEWEY]

Use this for criteria when entering start of field --
Like [Enter search] & "*"
Use this for criteria when entering end of field --
Like "*" & [Enter search]
Use this for criteria when entering any part of field --
Like "*" & [Enter search] & "*"