I believe this is a VB5/6 question NOT an Office or Database question.

I'm using Access and have made some stored queries (see below) for testing.
In Access query Builder, I:
1) Execute (double click) "TestA" and get back a recordset.
2) Execute (double click) "TestB" and get back a recordset.

"TestB" calls "TestA" and is dependent on "TestA" being executed first.

I cannot get "TestB" to be accepted as valid SQL in VB5/6 in order to run the query.

qryTestA:
Code:
SELECT * FROM tblTest;
qryTestB
Code:
SELECT TestA.fldHistDateTime, CDbl(TestA.fldHistDateTime)
FROM TestA;
------------
Question
------------
Is it possible to construct and execute dependent queries in VB5/6 -- using Access or any other DB for that matter as a backend -- and if so, how?