Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multi-line (row) Crosstab queries & Reports

Status
Not open for further replies.

WildHare

MIS
Mar 1, 2002
1,801
US
I have stumbled on a method to create MULTIPLE line cross-tab type reports which several of my co-workers have expressed gratitude for, as my employer does hundreds of cross-tab reports. It allows you have have MORE THAN ONE ROW/COLUMN intersection with a value in it, something like:

..........col1...col2....col3....col4...
MainRow
Row1 x x x x
Row2 y y y y
Row3 z z z z

and so on, overcoming the built-in limitation of one row per colum. For example, you can do a report by department with Budget, Projected, and Actual figures all lined up. This is NOT just a way around the "three row heading items" limitation, it's completely different.

My question is, would there be any interest out there in TekTips-land for me to put together a FAQ on this subject? I don't want to waste my time or yours if it's no big deal to most of you, but if a couple of people would like to see it, I'll put something together and post it up here, perhaps by the weekend.

I don't know if it's all that slick, but my coworkers went ga-ga over the ease with which it's done, so... ???

Post a reply here and I'll check in a day or so.

Jim Me? Ambivalent? Well, yes and no....
Another free Access forum:
More Access stuff at
 
Definitely!

I've struggled over the years with this and have cobbled together some of my own ways around this silly limitation, but I'd appreciate seeing another viewpoint.

Good job!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top