i have a photographic website which is primarily asp with access db. I can display the records from the db in either a single row or a single column but thats it, i would like to display records in a row and then when that row is complete to start a new row until the stipulated number of records has been displayed.

Try this.......

<table>
<%
Set Cnn = Server.CreateObject("ADODB.Connection")
Cnn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=C:\mydatabase.mdb"

sql="select * from products"
set rs=Cnn.execute(sql)

howmanyfields=rs.fields.count - 1

%>
<tr>
<%
for i = 0 to howmanyfields
%>
<th><%=rs.fields(i).name%></th>
<%
next
%>
</tr>
<%

do while not rs.eof
%>
<tr>
<%
for i = 0 to howmanyfields%>
<td><%=rs.fields(i).value%></td>
<% next%>
</tr>

<%

rs.movenext
loop

rs.Close
set rs=nothing

%>
</table>