query on parameters

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

Guest

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 worksheet ID, they can
type only a few letters and it will bring up anything that starts with that.
example of parameter: Enter the Worksheet 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
 
In the criteria of the Worksheet ID field write
Like [Enter the Worksheet ID] & "*"

In SQL it will look like
Select * From TableName Where [Worksheet ID] Like [Enter the Worksheet ID] &
"*"
 
Back
Top