>Craig,
>
> I am writing general function for that. I dont have specific fields but i can give example.
>
> I want to index the following fields
>
>1) Company C(05) Ascending
> AccountCode C(05) Ascending
> DueDate D Descending
INDEX ON Company + AccountCode + STR({^2100-12-31}-DueDate)
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer