barbarossaii
Master of Disaster
- Local time
- Today, 15:58
- 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
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