After typing in partial criteria, can Access search for all relate

[Guest]

Currently the query/report prompts for a Project Number when open.

Can I set the search criteria so that if the user only knows the first four
digits of the project number (the project number format is ####-####), the
query/report will give all projects that begin with those 4 digits?

 

[Rick B]

use criteria of...
Like [enter partial project number] & *

 

[Larry Daugherty]

Hi Karen,

There are lots of ways you can do what you want or things even more
powerful. Tell us what you are doing in your application when you
want this functionality.

HTH

 

[Tommy Borsh]

Rick B you are the most helpful person ever thank you very much i spent 2
hours trying to find this one piece of information now i can organize books

use criteria of...
Like [enter partial project number] & *

--
Rick B

Currently the query/report prompts for a Project Number when open.

Can I set the search criteria so that if the user only knows the first
four
digits of the project number (the project number format is ####-####), the
query/report will give all projects that begin with those 4 digits?