View Single Post
  #1  
Old April 23rd, 2010, 05:06 PM posted to microsoft.public.access.forms
Pascoe via AccessMonster.com
external usenet poster
 
Posts: 32
Default Graph displaying dates alphabetically on x axis, not by date

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#));

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201004/1