Zaraq,
How about:
INDEX ON ;
IIF(MONTH = "JAN",1,;
IIF(MONTH ="FEB",2,;
IIF(MONTH="MAR",3,;
IIF(MONTH="APR",4,;
IIF(MONTH="MAY",5,;
IIF(MONTH="JUN",6,;
IIF(MONTH="JUL",7,;
IIF(MONTH="AUG",8,;
IIF(MONTH="SEP",9,;
IIF(MONTH="OCT",10,;
IIF(MONTH="NOV",11,;
IIF(MONTH="DEC",12,0)))))))))))) TAG WHATEVER
HTH
Rex
>I have set a character field named Month with a regular index to store name of the months.When I use SET ORDER TO MONTH it indexes the field Month alphabetically as it is supposed to.How can I make it index on January , Feburary , March and so on instead of April, August, December etc....
>Thank You All
>Zaraq Bari
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only