Graph displaying dates alphabetically on x axis, not by date
in [Form]
|
From: Pascoe via AccessMonster.com on 23 Apr 2010 12:06 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/Forums.aspx/access-forms/201004/1
From: KARL DEWEY on 23 Apr 2010 13:19 Try an Order By [Date Paid] with not formating as that creates a text string. -- Build a little, test a little. "Pascoe via AccessMonster.com" wrote: > 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/Forums.aspx/access-forms/201004/1 > > . >
|
Pages: 1 Prev: It works - thanks! Next: Pivot table Control of height Access 2003 |