Having a problem while sorting the custom field (YYY-MM). checked many forum posts but looks complex for me. Please help me to sort based on the month and year.
Code:
TRANSFORM Count(qryAll.ArrivalMode) AS CountOfArrivalMode
SELECT Format([qryAll].[ArrivalDate],"yyyy/mmm") AS [Month]
FROM qryAll
GROUP BY Format([qryAll].[ArrivalDate],"yyyy/mmm")
ORDER BY Format([qryAll].[ArrivalDate],"yyyy/mmm")
PIVOT qryAll.FirstFacility;