Can I use a crosstab to transpose 2 fields?

R

RobR

I am trying to rearrange a set of data I have using a query. I think I need
some type of cross tab query, but I can't work out quite how:

My data looks like this:

Name Place

John London
John Paris
John New York
David London
David Paris
David Tokyo
Alan Paris
Alan Rome

But I want to change it into this format:

Name Places

John London, Paris, New York
David London, Paris, Tokyo
Alan Paris, Rome

or even:

Name Places 1 Place 2 Place 3

John London Paris New York
David London Paris Tokyo
Alan Paris Rome

whichever is easier. The sequence of the places is not important. My problem
when creating a crosstab is it requires 3 fields, and I don't know what the
third
field should be. I think maybe some kind of places counter? but thats as far
as I have got.

Any ideas would be much appreciated.

Thanks

Rob
 
Top