Jason, if I create 1 recordset as you suggested how can i code it so that in i can reference records 1 to 3 in one part of the page, 4 to 6 in another part of page, 7 to 9 in another and lastly records 10 to 12 in another area on the page. as the whole idea is to have 4 sections on the page displays highlighted featured products. the method i had used was just a simple recordset loop to showing 3 at a time (hence why i used 4 recordsets to achieve this) as i dont know how to manipulate certain records at a time.
Chris