Query a query with parameters

[imnewtoaccess]

Hi all,

I have created a query in msaccess with a parameter.

Now I want to query that query but without the parameter. Is it possible ?

[hyperpau]

Hi all,

I have created a query in msaccess with a parameter.

Now I want to query that query but without the parameter. Is it possible ?

yes it is. but since your new query is bound to a parameter query, each time you open that new query, it would ask you to input the parameter. you would think that it's your new query asking for the parameter but the truth is, it is the old query with the parameter which is asking for it.

so what you might want to do is to query the same table that the parameter query is querying. but this time, do not input a parameter.