lenevaosgmar
New member
- Local time
- Today, 06:20
- Joined
- Feb 24, 2018
- Messages
- 2
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;
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;