variable column and variable row reports 1

[drkhelmt]

Is there a way to assign a variable column and variable row query to a report?

I have an inventory query, that has the products as the columns and the warehouses as the rows. This is a crosstab query.

Any ideas on how to format this to a report?

Thanks in advance.

Andrew
a.k.a. Dark Helmet

"What's the matter Colonel Sandurz? Chicken?

 

[dhookom]

Variable rows is never an issue since every report has variable rows. To see the most flexible solution to dynamic column headings, check the sample at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.