Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chapo
Starting Member
39 Posts |
 Posted - 2008-05-09 : 09:22:43
|
| Is there a way to have the user type in the filter criteria as soon as the user opens up the query, kind of what is done in access by placing the message you would like to appear enclose in brackets under the Criteria column [Wo_No] so when they start the query it ask the user the Wo_No they would like to see. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-09 : 09:24:36
|
| Nope. The prompting of input value should be done only at your front end application.However, You can capture the user entered value and pass it as a parameter to query in SQL. |
 |
|
|
chapo
Starting Member
39 Posts |
Posted - 2008-05-09 : 10:07:57
|
quote:
Originally posted by visakh16
Nope. The prompting of input value should be done only at your front end application.However, You can capture the user entered value and pass it as a parameter to query in SQL.
Thank You |
|
|
|
|
|
|
Help with Query