>I tried your recommendation, and although it works, I need to order the Select by date, which gives me a problem.
>
>Do you have any other suggestions?
>
>Thanks
>Kev
Use two separate SQL Selects, the first retrieving the TOP records and the second selecting from that cursor and ordering by date.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao