Using Parameters in other Query (1 Viewer)

barbarossaii

Master of Disaster
Local time
Today, 11:27
Joined
Dec 28, 2002
Messages
70
Hello,

Is there the possibility to use the parameters of a parameter query as criteria or in an expression of another query ?

For example I got a query >MyQuery1< and a 'column' >SearchedColumn< with the parameter-criteria >[MyCriteria]<.
Can I use the result / the value of >[MyCriteria]< in a second query >2ndQuery< which is based on the frist query >MyQuery< ? I would like to use it as a criterium or in an expression like >IIF<.

I tried things like
=[MyQuery1]![MyCriteria]
but that didn't work....

TIA,
Barbarossa II
 

Fuga

Registered User.
Local time
Today, 11:27
Joined
Feb 28, 2002
Messages
566
If you create the second query with a link to the first query, won´t that do it?

If I missunderstood the question, I´m sorry.

Fuga.
 

Users who are viewing this thread

Top Bottom