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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting a Subform 1
How to use case in sql select 3
Textbox expression 3
last record in datasheet 1
Sort by problem 6
Sort by Any Field (Cursor Location) 2
Sorting date in subform 15
Form won't match query sort order 2

Back
Top