Graph displaying dates alphabetically on x axis, not by date

[Pascoe via AccessMonster.com]

Hello!

Title says it all - I want the x axis to show dates in DATE ORDER, not
alphabetical order.

I've read thru the forum, can't see how to fix it - your help will be
appreciated.

Kind Regards,
Russell.

p.s. Here is the graph Row Source, should there be an ORDER BY statement in
here?

SELECT (Format([Date Paid],"mmm"" '""yy")) AS Expr1, Sum([Tenant Payments].
Amount) AS SumOfAmount FROM [Tenant Payments] GROUP BY (Format([Date Paid],
"mmm"" '""yy")), [Tenant Payments].[Date Paid], (Year([Date Paid])*12+Month(
[Date Paid])-1) HAVING ((([Tenant Payments].[Date Paid])>=#3/1/2009#));

 

[KARL DEWEY]

Try an Order By [Date Paid] with not formating as that creates a text string.