Criteria Search Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have in my inventory a field for status and i need to be able to have a box
apear and me be able to type Com instead of complete and it bring up
everything that is complete only. Or with other than with customer. Im just
looking for a way to shorten of typing. Please help me thank you.
 
You can try using the "Left Function." Shorten the field
by typing the following expression:

Left([Your_Field-Name],3)

Now when you query on this field, typing "COM" would
return all records with "Complete." however, it would
also return any other word that begins with COM.

matt.
 

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

Access Dcount (multiple criteria) 3
Query Criteria 5
Help with query criteria 8
IIf statement in query criteria 3
Changing query criteria to supply a form 3
search multiple criteria 0
Parameter Query multiple criteria help 6
Criteria to return all records if selection from form is null 3

Back
Top