Query from a Query (1 Viewer)

[AccessProgram]

I created a query statement in a module. How can use that query as a record source of another query in the same module?

Should I use this like:

dim a,b as querydef

a=select * from tablename;
b=select * from a;

 

[ajetrumpet]

you can't do this. it's only available in the interface. and you can't use querydefs in this way, if you want to keep your sanity. but you CAN use recordsets that are opened with complex sql statements. might want to go that way

 

[AccessProgram]

I have no idea on this. I was also thinking about recordsets but I dont know how to construct it. Can you give me an example how to use the recordset for my purpose stated above wherein I use one query as record source for another query?