Special Sort Problem

  • Thread starter Thread starter Danny
  • Start date Start date
D

Danny

Hi, I would like to sort my records. I have an text field
and now i have chosen ASC. That is ok, because I have text
and year. But unfortunaltely the years comes befor the
text.

For example:

2005
2006
up to 2004

I would like that the text is always the first one an then
the numbers asc. is that possible.

Thzanks for your hel!
 
Year needs to be in its own field. Add that field to the query grid and sort
by it. You can still display the text; you don't need to see the field you
are using for sorting.
 
Back
Top