 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / February 2008Sorting X Axis of Graph embedded in a Form
I have months defined in a table that I need on hte X axis of a graph. But the sort order is alphabetic which does not sort by months of the year. I have tried putting a sort order by number; but it doesn't work. How can I sort this with Jan being the first month in the order. Apr and Aug show up first. You need to update the Row Source property to sort by the month number. If you can't figure this out, come back with the Row Source SQL view.  SignatureDuane Hookom Microsoft Access MVP > I have months defined in a table that I need on hte X axis of a graph. But > the sort order is alphabetic which does not sort by months of the year. I > have tried putting a sort order by number; but it doesn't work. How can I > sort this with Jan being the first month in the order. Apr and Aug show up > first. I have a query defined in the Record Source with this query sorted by the month number (Months.sort); but doesn't do the sort. I have even put in the Order By field of the form; but no luck. Maybe I need to not have a joining of two tables in the query to get this to work. Here's the SQL statement of the query: SELECT Months.sort, [Work Class Timewriting].[it Work Class], [Work Class Timewriting].Month, [Work Class Timewriting].Hours FROM Months INNER JOIN [Work Class Timewriting] ON Months.Month = [Work Class Timewriting].Month ORDER BY Months.sort; > You need to update the Row Source property to sort by the month number. If > you can't figure this out, come back with the Row Source SQL view. [quoted text clipped - 4 lines] > > sort this with Jan being the first month in the order. Apr and Aug show up > > first. This may help: I have created a chart embedded in a form without linking the form to a table or query. In the Chart: Graph0, it's got the Row SOurce defined: TRANSFORM Sum([Hours]) AS [SumOfHours] SELECT [Month] FROM [qry_it_work_class2] GROUP BY [Month] PIVOT [it Work Class]; How can I add an Order By clause to this statement to get it to sort right. I have tried before the Group By and at the end; My syntax must not be right to get it to work. > I have a query defined in the Record Source with this query sorted by the > month number (Months.sort); but doesn't do the sort. I have even put in the [quoted text clipped - 16 lines] > > > sort this with Jan being the first month in the order. Apr and Aug show up > > > first. I expect [Month] is the month name. If so, you need to go bac to qry_it_work_class2 and add a column that is the month number so you can use SQL like: TRANSFORM Sum([Hours]) AS [SumOfHours] SELECT [Month] FROM [qry_it_work_class2] GROUP BY [Month], MthNum ORDER BY MthNum PIVOT [it Work Class]; SignatureDuane Hookom Microsoft Access MVP > This may help: I have created a chart embedded in a form without linking the > form to a table or query. In the Chart: Graph0, it's got the Row SOurce [quoted text clipped - 27 lines] > > > > sort this with Jan being the first month in the order. Apr and Aug show up > > > > first. This worked. GREAT! Thanks for your help!!! > I expect [Month] is the month name. If so, you need to go bac to > qry_it_work_class2 and add a column that is the month number so you can use [quoted text clipped - 38 lines] > > > > > sort this with Jan being the first month in the order. Apr and Aug show up > > > > > first. Is there a way of building a chart similar to Excel by putting numbers into a datasheet and not linking the chart to a table or query? > You need to update the Row Source property to sort by the month number. If > you can't figure this out, come back with the Row Source SQL view. [quoted text clipped - 4 lines] > > sort this with Jan being the first month in the order. Apr and Aug show up > > first. The chart can be populated with values in a datasheet. However, you would need to write code to update these values in you want the chart values to be dynamic. I believe SteveA or SteveS used to post code that does this. You might want to search http://www.groupacg.com/. SignatureDuane Hookom Microsoft Access MVP > Is there a way of building a chart similar to Excel by putting numbers into a > datasheet and not linking the chart to a table or query? [quoted text clipped - 7 lines] > > > sort this with Jan being the first month in the order. Apr and Aug show up > > > first. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.