Parameters in queries and reports Access 2007

A quick and easy to follow video tutorial example of how to create a parameter query which reduces the number of stored (repetitive) queries in your database.

A parameter prompts you for a value and passes it into your query during the run-time (execution) of the query which makes it a more flexible query as it is now a variable value which is passed and not a fixed value within the design of the query (SQL statement).

This can then serve your forms and reports which in turn triggers the prompt. You can have more than one parameter too to make extra flexible and it applies to all versions of Microsoft Access (not just 2007)!

This entry was posted in MS Access, Queries and tagged , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.