Column Headings

[bstelloh via AccessMonster.com]

Can someone tell me if there is an easy way to utilize a different field name
for a coulumn heading in a crosstab query?
Issue: I have developed a Trip Database. I have created crostab queries to
view who participated in each trip with total count of participants. I was
using LastName as a column heading until I realized some people have the same
last name and it groups them together. I have since modified to use the
"Participant ID" which gives me the results I am looking for but having the
ID as the column heading is meaningless. I am hoping to add code to the
column heading property of the "Participant ID" field.

 

[Michel Walsh]

You can append the ID to the name:


PIVOT LastName & "_" & ParticipantID


Hoping it may help,
Vanderghast, Access MVP

 

[bstelloh via AccessMonster.com]

Thanks! That worked perfectly!

You can append the ID to the name:

PIVOT LastName & "_" & ParticipantID

Hoping it may help,
Vanderghast, Access MVP

Can someone tell me if there is an easy way to utilize a different field
name

[quoted text clipped - 8 lines]

ID as the column heading is meaningless. I am hoping to add code to the
column heading property of the "Participant ID" field.