If I am using a while wend loop to return only the records I want from the Database(MS Access) can I use those values to fill in a table. Or do I have to use the The fields Collection.
I retrive the records I want with the below script, the connection and everything is already made. But can I take those valuse and use them in a table. Also I need it to display all records in the fields I want so if I add or delete it will change with the DB. Any help would be great, Thanks!!!!

While Not objRecordset.EOF
    Response.Write objRecordset("ISBN")
 objRecordset.MoveNext
wend

__________________
-----------------------------------------------------------
\"Don\'t follow someone who\'s not going anywhere\" John Mason

I just dumped this out of my head, but it should more or less work.

If Not objRecordset.EOF Then
    Response.Write("<table>")
    Response.Write("<tr>")
    For Each objField In objRecordset.Fields
        Response.Write("<td>" & objField.Name & "</td>")
    Next
    Response.Write("</tr>")
    While Not objRecordset.EOF
        Response.Write("<tr>")
        For Each objField In objRecordset.Fields
            Response.Write("<td>" & objRecordset(objField.Name) & "</td>")
        Next
        Response.Write("</tr>")
        objRecordset.MoveNext
    Wend
    Response.Write("</table>")
End If


Peter
------------------------------------------------------
Work smarter, not harder.

Thank you