Maximize Crosstab Queries For More Flexibility in Your Query Results

摘要

Crosstab queries are one of the most valuable and least used features of Access. These queries produce a unique result set unlike any other in Access because the data, not the data table structure, determines the columns in the query results. The value of these queries is that you can generate a dynamic list of columns. In this article. I address how to control crosstab query result sets by using little-known query properties.