Crosstab - value is non-numeric, but doesn't work

[randysmid]

Hi ALL,
I need to create a crosstab query using a text field (non-numeric) instead of a number value as my "Value" column. Has anyone been able to do this?

Here's a sample of my raw data:
Adams, Amy "As The World Turns"
Adams, Amy "JAG"
Adams, Amy "Survivor"
Brown, Billy "Monday Night Football"
Cook, Chuck "ER"
Cook, Chuck "SportCenter"

Here's what I'd like the crosstab to create:
Adams, Amy "As the World Turns" "JAG" "Survivor"
Brown, Billy "Monday Night Football"
Cook, Chuck "ER" "SportCenter"

This output will be used in Microsoft Word Mail Merge to create letters.

TIA, Randy Smith

 

[PHV]

Instead of a CrossTab query you consider this:
faq701-4233

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886