Here is the full string:

SELECT tbl_ALLStatus.Status, Sum(Data.PBO) AS SumOfPBO, Sum([PBO]/[ABI]) AS Borrs, Sum([PBO])/Sum([pbo]/[abi]) AS Borr_ABI, Count(Data.BorrowerUniqueID) AS Loans, tbl_ALLStatus.StatusOrder, Sum(IIf([LoanTypeName]="Consolidation",[PBO],0)) AS Cons_PBO, Sum(IIf([LoanTypeName]<>"Consolidation",[PBO],0)) AS NonCons_PBO
FROM ((Data LEFT JOIN tbl_ALLStatus ON Data.Status = tbl_ALLStatus.Status) LEFT JOIN tbl_ABI ON Data.BorrowerUniqueID = tbl_ABI.BorrowerUniqueID) LEFT JOIN tbl_ALLLoanTypes ON (Data.LoanType = tbl_ALLLoanTypes.LoanType) AND (Data.LoanProgram = tbl_ALLLoanTypes.LoanProgram)
WHERE (((Data.PBO)<>0))
GROUP BY tbl_ALLStatus.Status, tbl_ALLStatus.StatusOrder
ORDER BY tbl_ALLStatus.StatusOrder;
It obviously works in Access. And I can't quite find the "<>" bracket spacing your talking about.