Re: query on parameters

Tech-Archive recommends: Fix windows errors by optimizing your registry

In the query, under the column, enter something like...

Like [Enter Spec] & "*"




--
Rick B



"Pam C" <PamC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F0C588EC-57EA-446D-93F6-7D9FA023F904@xxxxxxxxxxxxxxxx
If I want to run a query and have a parameter set to ask a question, what
do
I type in so when it prompts the user to enter the work*** ID, they can
type only a few letters and it will bring up anything that starts with
that.
example of parameter: Enter the Work*** ID
I now want the user to type in Spec or the first few letters and the query
will bring back Specialized Investigation (keeps the user from getting the
wrong info)
Help


.

Quantcast