Prompt For Unknown Parameter in WHERE

[ijitnoin]

Please Help!
In Access, you could enter an unknown parameter in the criteria and you will be prompted to enter the unknown value. The following is a sample WHERE:
WHERE (((qryBatchMFGInvoiceSum.MFG) = [Enter MFG Number, 5 positions]) AND ((qryBatchMFGInvoiceSum.MinOfInvoiceDate)
>= [Enter Beginning Invoice Date, 8 positions] AND (qryBatchMFGInvoiceSum.MinOfInvoiceDate) <= [Enter Ending Invoice Date, 8 positions])

The [Enter xxx] would cause a prompt and tell the user what you are looking for. Does SQL Server allow this in any way?

 

[SQLDenis]

No, you will have to write a GUI for that or connect from Access

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLSister]

If you want to do that create a stored procedure with input variables. Then create a form in your user interface that asks for the inputs and use those values to create the execution string for the stored procedure.

Questions about posting. See faq183-874
Click here to help with Hurricane Relief