I want to use pivot table to be able to show a report where, e.g., left
hand side are analysts assigned to projects, top is sponsors of
projects and values are the project names themselves. Any given
analyst could be working on 0 to n projects for any given sponsor. So
at ea intersection of analyst & sponsor the report provides a mini-list
of projects of interest to that pair of individuals.

There are other potential fields to include across the top, left or
page-field level, but the basic challenge is how to have something that
can dynamically present this kind of data.

I know access can do crosstabs but it has limitations (one column
heading, no such thing as page fields per se, for example).

Thoughts??? Thanks...