For your syntax is COUNT a field inside the database?<BR><BR>Because the records that recordset must obtain is all varied and depends on user input. So you end up getting records from beginning combined with records near the end. The only thing is all the records added up must be less than a certain number.<BR><BR>Thank you for the help
select top 2000 fields, fields, fields<BR>from table<BR>where criteria = criteria<BR><BR>But, why in the world would you allow a recordset to return that many records?! Your criteria should *always* force it to return less.
Thank you Thank you<BR><BR>It is becasue I must do a text match (like what you do when you search for title at the library). I got it narrowed down quite well and most search will result in less than 2000. But sometime some search results in up to 5000 records most of which are irrelevant. I sort it by assign a relevance value so the most relevance records come up if it is exists in the record set.<BR>