Question:
hello,
is it possible ?
i put 2 queries in one workbook, but don't see the values of the first query in the I_T_VAR_RANGE.
the first query has calyear and calmonth ... with the base of these values i want to filter a second query ....
i can't use offsets in one query to get the needed result.
thx for help,
toadward
Answer:
If you put the same variables on both queries, and run the 2 queries at the same time (select a non-query cell and click refresh, BEx offers to run all the attached queries), second query will take the first one's parameters which are common, and only ask if other variables are not filled in.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
there is a variable type "query result" or something like that... experiment with that
Answer:
hi,
a query result don't work in this case ...
i just made a table ...
when the first query is executed a custmer exit variable writes the valu into the table ...
the second query has just a second customer exit variable which read the valu from the table, make some changes and so on ...
so i put the value from one query to another, without using the same variable (which doesn't work in this case).
also i could not use offsets ...
but now it works and i want to share my solution