Crosstab results: Numeric vs Text

[FormerJarHead]

Hi all,

I have a crosstab query that gets its data from a select query. (3) Row Headings - (1) Column and (1) Value Heading. All works great except my Volunteer Row. In the report this query is based on, Volunteer is displayed as the VolID rather than the Volunteer name.

TRANSFORM Count(qryVolunteerVisit.LengthofVisit) AS CountOfLengthofVisit
SELECT qryVolunteerVisit.Group, qryVolunteerVisit.Volunteer, Count(qryVolunteerVisit.LengthofVisit) AS [Total Of LengthofVisit]
FROM qryVolunteerVisit
GROUP BY qryVolunteerVisit.Group, qryVolunteerVisit.Volunteer
PIVOT Format([DateIn],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");

Is there a way, with what I have, to display the Volunteers name rather than the VolID. In the Select query, I've joined first and last names, Volunteer:[FirstName]&" "&[LastName].



Thank you for any help you can throw my way...

[June7]

Include the constructed VolName field in the SELECT and GROUP BY clauses or join the CROSSTAB to the volunteer table to retrieve the names.