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.
 
Back
Top