Watch this: Make a query ask for input

January 31, 2008

Steven Thomas

Steven Thomas Want to make your query ask for input when it runs? Watch these demos to see how you can add parameters to a query, handle input that is the wrong kind of data, and use a form to collect parameters and then use them with multiple queries.

You can add parameters to a query in Design view. This first video demonstrates how to use parameters to make a query ask for a start date and an end date, and then use those values to limit the records returned.

Watch this Demo button

Parameter prompt

Help Button Problems watching the video? Try our troubleshooting tips.

To make your parameter query more robust, you can specify the data type that each parameter expects. This demo builds on the first example to show you how.

Watch this Demo button

Query Parameters dialog box

Help Button Problems watching the video? Try our troubleshooting tips.

If you want to reuse input values with multiple queries, you can create a form to collect parameters, and then connect that form to the queries you want. This demo builds on the previous two examples.

Tip   Try Office 2010In Access 2010, the Expression Builder has IntelliSense, so you can see what arguments your expression requires.
Watch a video or try Office 2010.

Note   This demo does not show you everything you might want to do with a parameter form. It shows you how to create a form, add controls to collect input, and use the input in your query design.

Watch this Demo button

Form displaying calendar control

Help Button Problems watching the video? Try our troubleshooting tips.

Applies To: Access 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language