Conditional MS Query
 

Currently I have two seperate MSQueries on seperate sheets, each pull
seperate info. The first collects all the stock info and the second collects
all the receipt info pertaining to a particular receipt referance.
Is is possible and if so how do I get query two to run and then run query
one on the output of query two, hense reducing the amount of data pulled from
the system and increaseing the speed of the reports.


Thanks in advance
Dean

Conditional MS Query
 

Try this:
After running Query2, select the destination sheet for Query1.
DataImport External DataNew Database Query
Use Excel files
Select the current file that you are in
Select the query2 data range
(Possibly named something like `Sheet2$Query2_from_Excel_Files`)
Then just continue building the query like normal.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Dean" wrote:

Currently I have two seperate MSQueries on seperate sheets, each pull
seperate info. The first collects all the stock info and the second collects
all the receipt info pertaining to a particular receipt referance.
Is is possible and if so how do I get query two to run and then run query
one on the output of query two, hense reducing the amount of data pulled from
the system and increaseing the speed of the reports.


Thanks in advance
Dean