Conditional MS Query

[Dean]

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

 

[Ron Coderre]

Try this:
After running Query2, select the destination sheet for Query1.
Data>Import External Data>New 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