Graph on Form - Overriding data

[Gabriel2012]

Hello, my graphs are pulling from a report that reports on data from the previous 6 accounting periods. This would be now be 8,9,10,11,12 in 2012 and 1 for 2013. My issue is that when the graph arranges the data is puts the "1" from 2013 in the front, Example A. I can open the graph and manually override the data to put period "1" after the "12" from 2012, Example B, however whenever the form reloads it automatically defaults back to the original format, Example A again. Any ideas?

[June7]

Need to include the year in the x values. Structure query so the data is like 201208, 201209, ... 201301.

[Gabriel2012]

Need to include the year in the x values. Structure query so the data is like 201208, 201209, ... 201301.

Hello June, thank you for the reply, can you be more specific? The gaph is pulling off of a query where the period and year each have their own column. Are you saying that in order to make this work I would need to merge them into one column, such as 201201, 201202? Can you please clarify?

[June7]

I don't know how to clarify further. Build query that constructs a field with an expression that shows values of YYYYMM. Use that field for the x data. Sorting follows very structured rules - 1 before 12. This means need more criteria for the graph to chronologically order the data - The year is a factor in chronological sort.

[Gabriel2012]

I don't know how to clarify further. Build query that constructs a field with an expression that shows values of YYYYMM. Use that field for the x data. Sorting follows very structured rules - 1 before 12. This means need more criteria for the graph to chronologically order the data - The year is a factor in chronological sort.

Thanks for the follow up June. I constructed a query that concatenated the "Year" and "Period" columns into a merged field so it is in the format of 20121, 20122, 20123, etc. The issue I am now running into is that the graph is still recognizing 20128 as a larger number than 201210 due to the first digit. I also attempted adding a 0 so it would come across as 201201, 201202, 201203, etc.. However this eventually creates a 2012010 and the same issue is faced.

If you have any other suggestions they would be appreciated it.

[June7]

Need placeholder 0, like:

201201
201202
...
201210
201301

[Gabriel2012]

Need placeholder 0, like:

201201
201202
...
201210
201301

Thanks, Understood. However I am unaware of how to achieve this. I can concatenate a field and add a 0 however it will also add that 0 to the 10 thus creating 2012010. Are you recommending some sort of "If statement" that only adds the zero if it is <=9?