SELECT DISTINCT
    MSP_RESOURCE_RATES.PROJ_ID, 
    MSP_RESOURCE_RATES.RES_UID, 
    MSP_RESOURCE_RATES.RR_RATE_TABLE, 
    IIF(MSP_RESOURCE_RATES.RR_FROM_DATE<=#1/1/1984#,Null,
        MSP_RESOURCE_RATES.RR_FROM_DATE) AS RR_FROM_DATE, 
    IIF(MSP_RESOURCE_RATES.RR_TO_DATE>#31/12/2049#,Null,
        MSP_RESOURCE_RATES.RR_TO_DATE) AS RR_TO_DATE,
    MSP_RESOURCE_RATES.RR_STD_RATE, 
    MSP_RESOURCE_RATES.RR_STD_RATE_FMT, 
    MSP_RESOURCE_RATES.RR_OVT_RATE, 
    MSP_RESOURCE_RATES.RR_OVT_RATE_FMT, 
    MSP_RESOURCE_RATES.RR_PER_USE_COST
FROM 
    MSP_RESOURCE_RATES
WHERE
    ((Not (MSP_RESOURCE_RATES.RESERVED_DATA)='X')) OR 
    (((MSP_RESOURCE_RATES.RESERVED_DATA) Is Null) AND 
    MSP_RESOURCE_RATES.RES_UID>0)
UNION (
    SELECT 
        MSP_RESOURCES.PROJ_ID,
        MSP_RESOURCES.RES_UID,
        0,
        MSP_RESOURCES.RES_AVAIL_FROM,
        MSP_RESOURCES.RES_AVAIL_TO,
        MSP_RESOURCES.RES_STD_RATE,
        MSP_RESOURCES.RES_STD_RATE_FMT,
        MSP_RESOURCES.RES_OVT_RATE,
        MSP_RESOURCES.RES_OVT_RATE_FMT,
        MSP_RESOURCES.RES_COST_PER_USE
    FROM
        MSP_RESOURCES
    WHERE  
        ((Not (MSP_RESOURCES.RESERVED_DATA)='X')) OR 
        (((MSP_RESOURCES.RESERVED_DATA) Is Null)  AND 
        MSP_RESOURCES.RES_UID>0)
)
ORDER BY 1, 2, 3, 4;