Please take a look at this:
To display these records, I have:
'declare your variables
Dim Connection, Recordset
Dim sSQL, sConnString
'declare SQL statement that will query the database
sSQL="SELECT TOP 10 ID, firstName, lastName, wolfID, telNo, stAddress, city, postCode, items, received, dispatched FROM tblWolf"
'Use "select * from ..." if you want to display all the records
'define the connection string, specify db driver and database location
sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("myDatabase.mdb")
'create an ADO connection and recordset
Set connection = Server.CreateObject("ADODB.Connection")
Set recordset = Server.CreateObject("ADODB.Recordset")
'Open the connection to the database
'Open the recordset object, execute the SQL statement
'HTML table to house our results
response.write "<table width='100%' border='1'>"
This is what you mean, isn't it?
I have a feeling that we are speaking at cross-purposes which is probably my fault.
When we establish that, I will elaborate a little more in my next post if that is OK?