Linda,

Not sure how well this came through but when indexing on fields that are non-character you need to convert:

INDEX ON STR(nMyNumber) + DTOS(dMyDate)

Also, to get the latest date use

INDEX ON STR(nMyNumber) + DTOS(dMyDate) DESCENDING

I use this a lot to find the last visit for a patient.

---

>thank you so much for your help i appreciate it
>i'll give these a try
>
>thank you Linda