Crosstab Report

[Guest]

When you have a crosstab report, you have an unknown set of columns and you
dont know how many there are. Is it possible to create a report that
automatically creates the columns?

 

[Guest]

The crosstab solution at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane allows you
to specify the number of columns during report design. There are limits to
the number of columns that will fit. When you run the report, extra columns
are "wrapped" beneath the first row. This allows virtually any number of
dynamic columns.