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] &
"*"
 
In the query, under the column, enter something like...

Like [Enter Spec] & "*"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query Won't Run 0
Parameter Query multiple criteria help 6
Modify Parameter Query 1
Update Query with Parameter 3
query parameters 2
Multiple Parameter Crosstab query filter by form 1
Select by first three digits 3
Using Combo Boxes as a Source for Parameter Queries 2

Back
Top