Report from Crosstab Query

[Rick B]

Fix your clock please.

 

[Duane Hookom]

If you can't hard-code the Rep values into the Column Headings property then
consider the solutions at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4

 

[T Martin]

I have Query1 that is a crosstab query with "Rep" as "ColumnHeading",
"Territory" as "Row Heading" and "Total" as "Value". I would like to use
that Query to create a report, but I can't use the field names, but they
change depending on the date range/active employees of query. Is this
possible to do?

thanks in advance.

 

[T Martin]

I'm on the east coast and that is what time it is here.

 

[T Martin]

Thanks for the direction Duane.

If you can't hard-code the Rep values into the Column Headings property then
consider the solutions at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4