hope somebody could clarify this for me and point me into the right


direction.

I think most of people are familiar with a concept of stacked queries,
they can also be called "query on query" They allows to extract
specific field or transform data. So the question is rather general.


Sample queries


QueryA:


SELECT Account, Date, Amount
FROM Table1


QueryB:


SELECT Date, SumOfAmount
FROM QueryA


Is there a way to accomplish this using VBA code and get the results of
QueryB?
How the results of the QueryA can be passed to QueryB within VBA code?


Thanks, any help would be appreciated