Quote Originally Posted by sal21
move all blank recordset in the top of table, i think ASC
I'm sorry, I skipped right over that. If you want to put all the NULL values on top, you can execute a query that will do that for you (you were right, ASC):
SELECT  Column
FROM Table 
ORDER BY Column ASC;
This is assuming there ARE NULL values in your returned data.
I think you can use that with your recordset rather than looping through the recordset.