This should be pretty basic, but since this is my first time going through and using dynamic sql it&#039;s not too obvious to me.<BR><BR>I need to have a dynamic recordset so I can count the number of records using RecordCount and work with the data from there.<BR><BR>Here&#039;s the code I have:<BR>----------------------------------<BR>SQL = "....."<BR>SQL = SQL & "....."<BR>Set db = Server.CreateObject("ADODB.Connection")<BR>db.Open "databasename"<BR>Set rs = db.Execute(SQL)<BR>----------------------------------<BR><BR>It returns records w/out a problem, but I need the dynamic recordset, how can I include that in my code?