The first thing to note when creating an Access Pivot table or a crosstab Ms Access Query is that they both handle the grouping and summarising of ‘detailed’ records which means in most cases this type of output reports are driven by the typical ‘SELECT’ based query. This article is not to show you how to create pivot tables or crosstab queries but how they differ; helping you to understand the key differences. If you want to know how, take a […]

Tags: access crosstab query, access pivot table, how to create a query, MS Access Query, using crosstab wizard, working with pivot tables