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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB Code to change Access Form field visibility for that record only 1
I want to search for a record... 2
Filling in fields to a partially complete record in a table using a form 0
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Access Command button to look up and copy data from a query to a table 0
Access -- Make a macro and relational lookup 2
How to find a record using more than one field? 4
Create a web site link from a part link and a data field in access 2003 1

Back
Top