dynamically generated crosstab query

[chuckfuller]

I'm having trouble with a dynamically generated crosstab query.
Basically, I've dynamically generated the correct query string with
VBA, but now I want to take the results of that query and filter them.
For example, I'd like to do something like this:

SELECT * FROM <name of crosstab query>
WHERE <some criteria>

The problem is that since the crosstab query is dynamically generated I
can't reference it from this second query. Is there a way to save the
dynamically generated query to an object so that I can reference it
from the second query?

Thanks!
Chuck

 

[Duane Hookom]

Create a query with any sql and save it as "qxtbDynamic". Then take your
generated SQL statement and use some DAO code to apply the SQL to the
querydef object.

CurrentDb.QueryDef("qxtbDynamic").SQL = strSQL

You now have a saved query with the appropriate SQL.