I don't understand this question.
If you want to sort by year and then by month, swap the order of the columns
in query design.
If you want to combine the two values, you could use:
Format([Field1], "mm\/yy")
though that will be less efficient.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Katarina" <ka********@ptt.yu> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...
Thank you very much for answers, Allen. That's it. :)
Yet, I have a question. How can I join(connect) a month and year during
sorting a month?
example:
05/05
01/05
10/05
and would be like:
01/05
05/05
10/05
How?
Thanks.