[AccessD] crosstab query

I prefer to automate the process using DAO and dynamic SQL.

Often downstream queries will not be constructed comprehensively if an
upstream query is a cross tab.

Using a macro that harvests the fields by looping through the columns
returned from a SELECT * query, I can modify the SQL in dependent queries.

I am guessing that in a more heavyweight system than Access this would be
encapsulated in a stored procedure.

Bill