Within my database is a table called tbProducts and one of the fields is called ProductID.
The records for this field are 1,2,5,7,9,20,46
Using a query I retrieve items 1,2,7,20,46
Assuming that I repeat region (loop) the results is there a way of displaying the number 4 (<%=.....%>next to the number 20.
As 4 represent the 4th record returned.
Does Get RowID or Currentrecord have anything to do with this?

I had similar problem and I solved it by adding another field to my products table for sorting the display order of my records. You could try that. The only problem would be that if you have thousands of records you would have to manually change the order, unless there is something better out there.