Make Query Ask For Input. Aug 15 12 at 1826. I am trying to create a query where the user will be able to input 2 dates at runtime.
Make a query ask for input - create a form that collects parameters. I know that approvals have a comment box but I need more choices so I am using email with options. You can make a query ask for input and its actually very easy.
Create a select query and then open the query in Design view.
A prompt will display asking for an artist. You can make a query ask for input and its actually very easy. You cannot prompt from sql to user for inputs if you are using web applications. X inputprompt y x10 At the prompt enter a numeric value or array such as 42.