Hello, I've sort of found a solution to this problem by using this below:
SELECT tblLSIP_PLASC_Data.Type, tblLSIP_PLASC_Data.Level, tblLSIP_PLASC_Data.Level_Name, tblPLASCGroupReq.PLASCGroup, Sum(IIf([Group]=[PLASCGroup],[2003/04],0)) AS [Y-4], Sum(IIf([Group]=[PLASCGroup],[2004/05],0)) AS...