VBA Excel: how to combine two Access queries
Posted on 2009-07-15
I have two queries:
1) SELECT * from fund_results_view WHERE [date] > #5/1/2009#
2) SELECT * from fund_results_view WHERE [date] > #12/1/2005#
I need to run the 2nd query on the results from the 1st query.
How can I do it in VBA excel? I tried QueryDef object, but it looks as it doesn't exists in ADO VBA excel. Is there a way of doing this in ADO?