Cross Tab Query

[Tammy]

I'd like to create a "cross tab" query that instead of summing/counting, I would like it to list the contents. I've draw a basic sample of what I'm looking to do. In some cases there will be more then one person on a project filling the same role (for example you may have several designers working on one project but only one project manager). Does anyone have any thoughts on how this might be accomplished?

All ideas would be appreciated.



Thanks

Tammy

[ranman256]

You will need a base query that looks like this:

NAME	PROJECT	ROLE
BOB	project 1	role 1
JEFF	project 2	role 1
JANE	project 3	role 1
SARA	project 4	role 3
RANDY	project 1	role 3

Then create a crosstab query on THAT query and put PROJECT as row headers, ROLE as col headers, and NAME as the intersection (use FIRST. instead of SUM, or COUNT ,use FIRST)

[ranman256]

use the crosstab wizard. it guides you perfectly thru the steps.

[Tammy]

My experience with First is that it will only provide you with one person per role but if there are several designers, only the first one will show up on this type of query.

Is there a way to ensure that all participants are listed instead of just the First or Last?

Thanks

Tammy

[June7]

Not with a simple CROSSTAB.

Review: http://allenbrowne.com/func-concat.html