Create a crosstab report with dynamic column headings. This exampkle is based on this Microsoft KB article: How to create a dynamic crosstab report in Access 2002

You can use Microsoft Access to create dynamic reports that are based on parameter crosstab queries. You can also create reports to match a dynaset that is returned by such a query. Dynamic reports allow your customized reports to show only the most recently modified data. This gets rid of the need for fixed column headings and empty columns.

The following example uses starting dates and ending dates that are entered on a form as the parameters in a crosstab query. When a button on the form is chosen, Microsoft Visual Basic for Applications (VBA) functions run the crosstab query that creates a dynaset. The contents of the dynaset are then presented in a report.

In the following example, the report shows the employees that have sales for a certain period of time. The employees that appear in the report are based on the dates that are entered on the form. The steps below show how to create a dynamic crosstab report based on tables in the sample database Northwind.mdb.

 The download includes databases in Microsoft Access 97 and Microsoft Access 2000.  formats  This will allow anyone with Access 97, Access 2000, Access 2002, Access 2003, and Access 2007 to use this example.