(Select IIF(GBL.BU='GBL DLV','Horizontal','Vertical') as Unit, IIF(GBL.BU='GBL DLV','BTOFF',GBL.BU) as BU,GBL.Proj_Vertical,AVG(GBL.FTE) as Off_FTE,AVG(GBL.AVB) as Off_ABP,AVG(GBL.TBH) as Off_TBH,AVG(GBL.UTL) as Off_UTL,AVG(RTBL.FTE) as Tot_FTE,AVG(RTBL.AVB) as Tot_AVB,AVG(RTBL.TBH) as Tot_TBH, AVG(RTBL.UTL) as Tot_UTL,GBL.Month From
(Select BU,Proj_Vertical,Sum([AVA FTE]) as [FTE] ,Sum(ACGHRAWP) as [AVB],Sum(TotBLDHR) as [TBH] ,IIF(Sum(TotBLDHR)=0,'0',(Sum(TotBLDHR)/Sum(ACGHRAWP))*100) as [UTL],Month From GeowisebilledMain Where Proj_Vertical Not In ('CIO OFFICE','GBM','STG') And Emp_Curr_Location='OFFSHORE' And Month > CDate('5/28/2012') And (Month between @StartDate and @EndDate) And BU Not in ('SUPPORT','ES') Group By BU,Proj_Vertical , Month Order By Month Desc) as GBL
FULL OUTER Join
(Select BU,Proj_Vertical,Sum([AVA FTE]) as [FTE] ,Sum(ACGHRAWP) as [AVB],Sum(TotBLDHR) as [TBH] ,IIF(Sum(TotBLDHR)=0,'0',(Sum(TotBLDHR)/Sum(ACGHRAWP))*100) as [UTL],Month From GeowisebilledMain Where Proj_Vertical Not In ('CIO OFFICE','GBM','STG') And Month > CDate('5/28/2012') And (Month between @StartDate1 and @EndDate1) And BU Not in ('SUPPORT','ES') Group By BU,Proj_Vertical,Month Order By Month Desc) as RTBL On RTBL.Proj_Vertical = GBL.Proj_Vertical And RTBL.Month=GBL.Month Group By GBL.BU,GBL.Proj_Vertical,GBL.Month)
This Query is not working in MS Access. Can anyone sugget me some other solution.