Parameter Query Box For Every Field

Asked By 20 points N/A Posted on -
qa-featured

I have created a simple database with 12 fields both text and numeric.

The query I’ve chosen shows the value of each field.

Why can’t the query see the database and gives me a parameter query box for every field when I shut down the database and reopen it?

I should specify that when I save the query, close it and re-open it works just fine.

SHARE
Answered By 0 points N/A #171227

Parameter Query Box For Every Field

qa-featured

Hello!

A parameter query is  an advanced query. You can create a query that can be updated easily to refer to a new search term. 

In parameter queries, search terms act as variable criteria and change each time you run the query. 

The solution to your problem requires a very detailed solution, however I was able to find some useful links for you.

Use a parameter to make a query ask for input

Customizing Access Parameter Queries

Hope it helps.

 

Related Questions