ORDER date period ....

[sal21]

Attached is the rapresenation of my table1 in Access.

i need a logical order in Sql query (vb6).
sure the first index is the year on right, but the second?

Tks

[HansV]

You can use code that I wrote for you in the past - see

get the last 2 periodi oldest based one....
update field LASTDAY form each period in other field
Use function in query...