I currently have a solution that requires 2 sub queries, where each of
them is convereted into a crosstab query and then I join the crosstab
queries to a result. I would like to make this more dynamic and
allow for users to filter, and to do so I would like to be able to
create the resulting query all in VBA code.
I can create a recordset of each inital query, but is there a way to
run a query on that, and then subsequently, a query on that returned
recordset.. so i may create the desired recordset for the report?