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

2) Company C(05) Ascending
AccountCode C(05) Ascending
DueAmount N(15,2) Descending

HTH
Amit

>Can you post a list of fields, their types, and which you want >ascending/descending and we'll be able to create an INDEX statement.