Ascending Date order

[gtsolid]

Good morning,
I selected and organized some data from a table, and now i'd like to sort them in a chronological way.
If I use

ORDER BY Format([Data],"yy/mm");

I will get this: January of each year is prompted.
Is it possible to sort them in the correct way?

[Bob Fitz]

Create a hidden column for both the year and the month and sort on those columns.

[gtsolid]

The table has too many records to be modified now:
Do you mean this? to add hidden columns in the table or in the query? in the latter case I don't understand

[Bob Fitz]

The table has too many records to be modified now:
Do you mean this? to add hidden columns in the table or in the query? in the latter case I don't understand

No. I was talking about sorting the records from within a query.
If the field that you want to sort by has a DataType of Date/Time then you would be able to select either Ascending or Descending in the Sort Row of that field when the query is in Design View

[moke123]

The table has too many records to be modified now:
Do you mean this? to add hidden columns in the table or in the query? in the latter case I don't understand

As an aside, Data and In are reserved words and should not be used as field names

http://allenbrowne.com/AppIssueBadWord.html#D

[CJ_London]

would be helpful to see the full sql to your query and some example data since what you have tried should have worked (i.e. assuming data is a date datatype) but what you are showing is another field displayed as mm-yy or perhaps mm-dd

[gtsolid]

That's the full SQL

SELECT Format([Data],"mm/yy") AS Mese, Sum(IIf([In]=0,([Importo]),0)) AS totUscite, Sum(IIf([In]=-1,([Importo]),0)) AS totEntrate, Format$(Abs([totUScite]/[totEntrate]-1),"0%") AS [Risparmiato%], ([totEntrate]-[totUScite]) AS Risparmiato, Round(([totUScite]/31),0) AS [€/gg]FROM Movimenti
GROUP BY Format([Data],"mm/yy"), Format([Data],"yy/mm")
ORDER BY Format([Data],"yy/mm");

[CJ_London]

and some example data from Movimenti?

[gtsolid]

and some example data from Movimenti?

Here it is

[CJ_London]

please provide data in a format that can be copied into a table (excel will do)- remove columns not required.

[gtsolid]

Here it is Movimenti.zip

[CJ_London]

your query per post#7 and data provided works for me

Mese
12/15
01/16
02/16

[gtsolid]

I use "Remove sort" button and worked also for me... What a shame! thanks!