View Parameter

[Smart]

In access you can in a query type [Please enter name] in the criteria section and when the query runs it asks for a parameter.

My question is how do I achieve this with a view in SQL?

(I know how to achieve it with a stored procedure)

Any Help gratefully received

Thanks

 

[SteveMc]

Fairly sure you can't do this with a View.

Maybe you could create a Stored Procedure that captures parameter data and then executes a View (with parameter).

 

[giovi2002]

You could filter your view in access with the form properties but it would be better to use your view in the stored procedure and make a parameter in the SP.