SELECT 
    MSP_PROJECTS.PROJ_NAME AS Project, 
    [Task Cost Type].TEXT_VALUE AS [Cost Type], 
    [Resource Groups].TEXT_VALUE AS [Resource Group], 
    MSP_RESOURCES.RES_NAME AS [Resource Name], 
    [Resource Rates].RR_RATE_TABLE AS [Rate Table], 
    [Resource Rates].RR_STD_RATE AS [Standard Rate], 
    Sum((MSP_ASSIGNMENTS.ASSN_WORK/MSP_PROJECTS.PROJ_OPT_MINUTES_PER_DAY/1000)) AS [Work], 
    Sum((MSP_ASSIGNMENTS.ASSN_COST/100)) AS Cost
FROM 
    (((MSP_PROJECTS 
        INNER JOIN (MSP_ASSIGNMENTS 
        INNER JOIN [Resource Rates] 
            ON (MSP_ASSIGNMENTS.PROJ_ID = [Resource Rates].PROJ_ID) 
            AND (MSP_ASSIGNMENTS.RES_UID = [Resource Rates].RES_UID) 
            AND (MSP_ASSIGNMENTS.ASSN_COST_RATE_TABLE = [Resource Rates].RR_RATE_TABLE)) 
            ON MSP_PROJECTS.PROJ_ID = MSP_ASSIGNMENTS.PROJ_ID) 
        INNER JOIN MSP_RESOURCES 
            ON (MSP_ASSIGNMENTS.PROJ_ID = MSP_RESOURCES.PROJ_ID) 
            AND (MSP_ASSIGNMENTS.RES_UID = MSP_RESOURCES.RES_UID)) 
        LEFT JOIN [Resource Groups] 
            ON MSP_RESOURCES.RES_UID = [Resource Groups].TEXT_REF_UID) 
            LEFT JOIN [Task Cost Type] 
            ON (MSP_ASSIGNMENTS.PROJ_ID = [Task Cost Type].PROJ_ID) 
            AND (MSP_ASSIGNMENTS.TASK_UID = [Task Cost Type].TASK_UID)
GROUP BY 
    MSP_PROJECTS.PROJ_NAME, 
    [Task Cost Type].TEXT_VALUE, 
    [Resource Groups].TEXT_VALUE, 
    MSP_RESOURCES.RES_NAME, 
    [Resource Rates].RR_RATE_TABLE, 
    [Resource Rates].RR_STD_RATE, 
    MSP_ASSIGNMENTS.RES_UID
HAVING 
    MSP_ASSIGNMENTS.RES_UID>=0
ORDER BY 
    MSP_PROJECTS.PROJ_NAME, 
    [Resource Groups].TEXT_VALUE, 
    MSP_RESOURCES.RES_NAME, 
    [Resource Rates].RR_RATE_TABLE;