Hi All,

I would like to index on a character field, name_horse c (18), and a date field "serv_date.

The name_horse field should alphabatize a to z and then the serv_date field from the most current date to the oldest.

Amber Hanover 02/10/2003
Amber Hanover 02/09/2003
Amber Hanover 01/23/2003
Amber Hanover 12/21/2002
Babs 02/09/2003
Babs 02/02/2003
Babs 10/23/2002
Corinne Lobell 02/08/2003
Corinne Lobell 02/02/2003
Corinne Lobell 01/10/2003

This index alpha's the name okay, but the dates are oldest to newest
name+DTOS(date_serv)

If I declare the index when I open the table as:
"use healthvet order name_horse desc"
The dates are descending, but the names start with the "Z's".

This gives me an error message.
name+desc(DTOS(date_serv))

Is there a way to mix field types and have one ascending and the other descending?

TIA
Jim Harvey
jharvey@hanoverpa.com