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

  • Thread starter Thread starter gdmoland
  • Start date Start date
G

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
 
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] & "*"
 
Back
Top