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

K

Karen

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?
 
L

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
 
T

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

Rick B said:
use criteria of...
Like [enter partial project number] & *

--
Rick B



Karen said:
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?
Click to expand...
Click to expand...
 
Top