for example, i have 3 query levels...one bulids on the next.
Query1 returns some results to query2, query2 returns some results to query3, then i want to use the query3 data.
i would like to implement this in VBA instead of using the queries.
i know the standard way to run sql commands in VBA is similar to this:
dim sql as string
sql = "sql code here"
docmd.runsql (sql)
but how can you do multiple level queries in that manner?