question

I am converting an Access database to SQL server 2014. I have a crosstab query that is giving me fits. How do I convert this to a SQL pivot? TRANSFORM Sum(qryMovLoc_Insp_All.Qty) AS SumOfQty SELECT qryMovLoc_Insp_All.LJOBNO, qryMovLoc_Insp_All.LTRACKING, Sum(qryMovLoc_Insp_All.Qty) AS [Total Of Qty], Sum(IIf([reason]="ok",[qty],0)) AS Good, Sum(IIf([dept]="scrp",[qty],0)) AS Scrp, Sum(IIf([reason]="ok" Or [reason]="ang" Or [reason]="bsf" Or [reason]="cnt" Or [reason]="bvp" Or [reason]="chp" Or [reason]="ctm" Or [reason]="ctp" Or [reason]="dig" Or [reason]="flw" Or [reason]="frc" Or [reason]="frn" Or [reason]="odm" Or [reason]="mms" Or [reason]="mst" Or [reason]="pps" Or [reason]="scr" Or [reason]="smr" Or [reason]="spt" Or [reason]="stn" Or [reason]="ull" Or [reason]="wdg",0,[qty])) AS Other FROM qryMovLoc_Insp_All GROUP BY qryMovLoc_Insp_All.LJOBNO, qryMovLoc_Insp_All.LTRACKING ORDER BY qryMovLoc_Insp_All.LJOBNO, qryMovLoc_Insp_All.LTRACKING PIVOT qryMovLoc_Insp_All.Reason;