If I use predefined queries (closest Access comes to SQL&#039s stored procedures) what order of speed do I get from the options of parsing data in the query itself, by parsing during assigment of the returned data to a variable or just using Response.Write?<BR><BR>As a simple example:<BR>SELECT FirstName & " " & LastName As Name FROM ....<BR>Response.Write rst("Name")<BR><BR>or<BR><BR>SELECT FirstName, LastName FROM...<BR>varName = rst("FirstName") & " " & rst("LastName")<BR>Response.Write varName<BR><BR>or<BR>SELECT FirstName, LastName FROM...<BR>Response.Write rst("FirstName") & " " & rst("LastName")<BR><BR>ALSO:<BR><BR>Is it quicker to loop through a Recordset using<BR> Do Until rst.EOF<BR> Response.Write rst("Name")<BR> rst.MoveNext<BR> Loop<BR><BR>or through an array containing the returned recordset using either a For..Next routine with the record count or a Do...Loop with a test on the UBound value.<BR><BR>(Note I am not up to speed on COM yet)<BR><BR>Many thanks,<BR>Howard