Queries in Visual basic

[Helen Blackburn]

Can some one please help. I am a bit of a beginer when it comes to data reports in visual basic. I have data reports that are based on queries in an access database, some of these queries are queries based on queries. Is there any way that i can base a query in visual basic on another query in visual basic? I am using commands and with SQL statements

[Clunietp]

you should be able to query on a query:

select * from [my query name here] where [condition]....

[RogerH]

Instead of using queries: Every query is a SELECT command, right? So why don't you just use

SELECT * FROM (SELECT * FROM (SELECT ...) WHERE ...) WHERE ...

Roger