Parameter on Two Queries

[JoeCL]

Hi!

Is there a way to pass on a parameter value of one query
to another query? Example, I created a parameter query and
that same parameter query would be used to filter records
for another query without re-entering/displaying the
parameter. Thanks.

 

[fredg]

Hi!

Is there a way to pass on a parameter value of one query
to another query? Example, I created a parameter query and
that same parameter query would be used to filter records
for another query without re-entering/displaying the
parameter. Thanks.

If the first query is used as the table for the second query, what you
are asking for is automatic.
Just select the query from the "Show Table" dialog box that appears
when you select "New Query".