I have a totals query that I have linked to a bar chart in a report. What is the best way to have it display the "mmm" abbreviation without sorting it in alphabetical order? My query has a TransactionMonth field and a TransactionAmount field. The TransactionMonth field pulls from a date field using MonthName(Month([TransactionDate]),1). I could just use Month instead of MonthName, but that doesn't look as nice...
When researching I saw mention of ORDER BY, but I'm unfamiliar with SQL and wasn't able to quite figure that out.