Special Sort Problem

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!
 
B

BruceM

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.
 
Top