Chart sort

[Egg 'n' Bacon]

Well I'm back again.

I know I've had this before, but no memory of how or where I have the solution.

In a nutshell; I have a query that has a sort by month-year. The chart however sorts this alphabetically

Ideas please?

[HansV]

Can you format the date as yy-mm or yyyy-mm?

[Egg 'n' Bacon]

The query is in date format (though I tried mm-yyyy too) & sorts appropriately, but the chart still re-sorting to alphabetical.

[HansV]

Try replacing the date field with a calculated column

Format([DateField],"yyyy-mm")

where DateField is the name of the date field.

Explanation: The Chart Wizard in Access tends to create a crosstab query from the query you provide. The column field of a pivot table is treated as text, even if it is a date field.

[Egg 'n' Bacon]

Didn't quite get that, but it got me looking in the row source for the chart. That was quite an education!

What I tried (that worked ) was replacing the SQL with that of the query. Now it works.

Cheers hans

[HansV]

Good for you!