[AccessD] crosstab query

Bill Benson bensonforums at gmail.com
Thu Jul 3 11:01:49 CDT 2014


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


More information about the AccessD mailing list