Create a parameter query in Access 2010

Parameter are flexible queries that allow the end user to enter a search term after running the query.

Step 1: Click the Create tab then click query wizard.

Query Wizard Access

Step 2: Select the fields you would like to use in your query. Tip- you can select fields from multiple tables from the drop down list for Tables/Queries before you move to the next step in the wizard.

Query Wizard Access what fieds

Step 3: In the summary options, choose detail if you want to show every field of every record or click summary for summary options like sum, average, and count functions.

Query Wizard Access

Step 4: Name the query on the last step of the query wizard and click finish.

Query Wizard Access what title

Step 5: Navigate to the design view of the query. On the criteria line below the field you want to search, type inside of square brackets a prompt for the end-user. NOTE- The prompt can’t be the same as your field name.

parameter query

Now that the parameter query is set up, run it and you will get a box that states “Enter Parameter Value” on the title and also displays the prompt typed inside of square brackets.

enter account executive

Enter the search term, click OK, and view the results.

data entered

This parameter value returns the following results.

Access query resultant records from parameter


About Steve Chase

I want to help you work in your business, so you can work on your business. I want to help you achieve your goals and help you have a successful small business journey. I understand that keeping up with the latest technology and cloud based computer trends can be difficult, when you’re running your day to day business. But, it is crucial that you keep up with the technology and best understand your options, in order to thrive in this new era of online business. I can help you discover the right software and tools for your business, train your team on how to use them, and mentor you to best serve and delight your customers. My certifications include: QuickBooks ProAdvisor, Microsoft Office Specialist Master, and OntraPort Certified Consultant. Please contact me on my new website at
This entry was posted in Access and tagged , . Bookmark the permalink.

3 Responses to Create a parameter query in Access 2010

  1. Pingback: The Top 10 Posts of 2012 on my 1 year Blog Anniversary | Steve Chase Docs

  2. Leo Rozenblat says:

    Hi Steve, thanks for your notes, descriptions and answering people’s questions. I have a small one for you. I need to pass more than 1 parameter to an Access query. And it could be 2, 3, 4, 5, etc… I don’t know how many, it depends on a user. Is there a way to build such functionality with Access, so your pop-up would be labeled “Enter Executives” and it takes a comma separated list of values? Or may be there is some other way to accomplish this task?


    • Steve Chase says:

      I don’t know how the commas would work without some VBA code. But I do know that you can solve this with creating multiple parameters. The user will see one box at a time.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s