Update;
Thanks Again Mark. Took a little playing around but I did get this to work. Used both of your suggestions. :)
I added a field to my final query:
Sorting: DateSerial((Right([Graph-water counts high monthly].[month],4)),(DatePart("m",[Graph-water counts high monthly].[month])),1)
That...