I'm a little confused. What does the data look like in your query? Can you show a screenshot and a screenshot of the chart?

I've got another item on my TechHelp list that someone sent in a while ago. It's basically the same thing they want to sort based on their fiscal year. So I'll do tomorrow's TechHelp video based on that. That might give you the answer you're looking for.

Sorry for late reply just getting some screen shots together

That's it with chart not summing up the quarters ie basically just still the months but giving the quarter number which is in the correct order although not summed up into each quarter

This last one is showing the chart before I fix all the formatting but now the quarter is in the  wrong place ie 4 should be before 1 but that's probably because the chart can only see Q1 and Q4 so it arranges in that order. ie it can't see my order from the YearMonthField.

I think I need to make Q4 associated with year 2024 somehow and I suppose it won't matter if I say make Q4 in 2025 minus one year making it Q4 2024 ?

  Is my logic flawed there?

Watch the tech help video that I just recorded for tomorrow. It'll go live at 9:00 a.m. Eastern.

I got my quarters from a Choose(DatePart("q",[last_Done]),4,1,2,3)

I will thanks Richard

Stanley That's basically what I did in the video with an IIF statement. Choose works just fine.

But you still end up with the same problem -- the chart will need some way to reference Q4 as Q4 of the previous year but I'm not sure how to do that. Maybe using yyyy -1 if quarter = Q4 would work.

ie I now have the sum of items done in their proper quarters but the query still orders them Q1, Q4 instead of Q4 Q1
ie
183 Q1
233 Q4

What I really need is
233 2024 - 4
183 2025 - 1

  But I'm not sure how to get to that -- maybe concatenation of quarter and year after an iif to put Q4 to previous year.

Yes, you could create one field that concatenates the year and quarter together, and then you can sort your chart based on that concatenated field.

2024-4
2025-1
2025-2
2025-3

I got it sorted -- I was trying to get the quarters from the "Month Done Query" -- OK for just seeing the quarters / month on a query but for  access charts you really need to have the quarters only and sorted properly as is the subject of this thread.

  What I did was to make another query off the "Month Done Query" which gets it's information from another query where I do the number crunching bit and the Start and End dates are sucked off a dedicated Reports form ( I made it from one of your videos -- which was very helpful thanks )

  The month done query is where the proper quarter is found using the Choose function and the count of items ( DevnumbsDone ) is counted.

  Then the new " Quarter Done query" is where the magic happens to change the year for Q4 with the formula;

   Q4YEAR: IIF([NewQuarterDone]=4,[NewYearDone]-1,[NewYearDone])&"-"&[NewQuarterDone]

  I did the same sequence of queries for Overdues in the same month hence I could make a percentage performance chart.

This way I can have everything built into one application ie Access and it updates live so all the user needs to do to see the monthly or quarterly Percentage performance charts for quality control is set the Start and End Dates they wish to see a chart for and select which chart they want -- the start and end dates stay on the form so they don't have to type it in every time.

  Much better than having to export it to excel and poke around with that when it's just a simple chart they need to see and fast.