Crosstab Query Formatting (1 Viewer)

I'm new to queries within Access and could use some insight. I'm trying to get the datasheet view to display an "X" instead of repeating the column titles. Any help would be appreciated. Thanks in advance.

TRANSFORM [SOPList].[SOPTitle]
SELECT [Job Titles].Title
FROM [Job Titles] INNER JOIN (JobTitle_Curriculum INNER JOIN (SOPList INNER JOIN Curriculum ON SOPList.SOPID = Curriculum.SOPID) ON JobTitle_Curriculum.ProgramID = Curriculum.TrainingProgramID) ON [Job Titles].TitleID = JobTitle_Curriculum.TitleID
GROUP BY [Job Titles].Title
PIVOT SOPList.SOPTitle;

A picture would help. Show what you have and then show what you want.

Like Pat, struggling to understand what you are trying to achieve, but the way to get an X in the data area is this

TRANSFORM First("X")

CJ_London said:

Like Pat, struggling to understand what you are trying to achieve, but the way to get an X in the data area is this

TRANSFORM First("X")

Click to expand...

This is exactly what I needed, thank you!