this is a query to calculate records.<BR>It will take some time before there are enough records that will will come to be in the value range this query is looking for.<BR>Works good if the end value is there. But for starting off it hangs the server.<BR>this is an access Db. And not looking to add records just search them out.<BR>any suggestions?<BR>&#060;%<BR>If IsObject(Session("stat_conn")) Then<BR> Set conn = Session("stat_conn")<BR>Else<BR> Set conn = Server.CreateObject("ADODB.Connection")<BR> "stat","",""<BR> Set Session("stat_conn") = conn<BR>End If<BR>%&#062;<BR>&#060;%<BR>If IsObject(Session("Ctl_1tourneychamp_rs")) Then<BR> Set rs = Session("Ctl_1tourneychamp_rs")<BR>Else<BR> sql = "SELECT playerspoints.Member, playerspoints.Points FROM playerspoints WHERE (((playerspoints.Points)&#062;=100 And (playerspoints.Points)&#060;=199)) ORDER BY playerspoints.Points "<BR> Set rs = Server.CreateObject("ADODB.Recordset")<BR> rs.Open sql, conn, 3, 3<BR> If rs.eof Then<BR> rs.AddNew<BR> End If<BR> Set Session("Ctl_1tourneychamp_rs") = rs<BR>End If<BR>Session.Abandon<BR>%&#062;<BR><BR>thanks in advance