Code:
TRANSFORM Sum(tblAccountTransactions.TotalPayment) AS [SumOfTotal Payment]
SELECT FORMAT([EntryDate],"yyyymm") AS [MonthNo], Format([EntryDate],"mmm") AS [MonthTxt]
FROM tblAccountTransactions
WHERE (((tblAccountTransactions.TransType) Not Like " ") AND (((Year([EntryDate])*12+Month([EntryDate])-1)) Is Not Null) AND ((tblAccountTransactions.Category) Is Not Null And (tblAccountTransactions.Category) Not Like 86 And (tblAccountTransactions.Category) Not Like 85 And (tblAccountTransactions.Category) Not Like 90) AND ((tblAccountTransactions.EntryTitle) Not Like "setup") AND ((tblAccountTransactions.TotalPayment)>0))
GROUP BY FORMAT([EntryDate],"yyyymm"), Format([EntryDate],"mmm")
PIVOT tblAccountTransactions.TransType;
, and add an ORDER BY FORMAT([EntryDate],"yyyymm") clause (an unfamiliar syntax for me, so you have yourself to find out where to put it).
PS. I changed query column name [Month] to [MonthTxt], as Month is a reserved word - better to be consistent in avoiding using it freely.