Below is my code for looping through the database:

<% Do While NOT RS.EOF
if len( trim(rs.Fields("CompanyName"))) > 0 then %>

<b><%=strCoName %> </b> <br>
<%=strConName %> <br>
<%=strAddress%> <br>
<%=strCity%> &nbsp; <%=strState%>&nbsp;&nbsp;<%=strZip%> <br> <br>
<br><br>
<p>Test Request: <%=strWhichTest%> <br>
<%=strDesc%> <br>
<p>Test Method:</p><%=TMethod%> <br>
<p>Notes:</p><%if TestNotes <> "" then %>
<%=TestNotes%>
<%end if%> <br>
<p><u>Results:</u></p>
<table border="0" width="90%" cellspacing="1" cellpadding="0">
<tr>
<td width="14%" align="center">Sample</td>
<td width="14%" align="center">Sample2</td>
<td width="14%" align="center">Sample3</td>
<td width="14%" align="center">Sample4</td>
<td width="14%" align="center">Sample5</td>
<td width="14%" align="center">Sample6</td>
<td width="14%" align="center">Average</td>
</tr>
<tr>
<td width="14%" align="center"><%=dblSample%></td>
<td width="14%" align="center"><%=dblSample2%></td>
<td width="14%" align="center"><%=dblSample3%></td>
<td width="14%" align="center"><%=dblSample4%></td>
<td width="14%" align="center"><%=dblSample5%></td>
<td width="14%" align="center"><%=dblSample6%></td>
<td width="14%" align="center"></td>
</tr>
</table>
<%end if
RS.MoveNext
Loop

%>

It does not gives me any error message, but i only get the first customer from the database and it is displaying the same customer twice (since i only input two customers for testing purposes.)

thanks

Try using a Do Until loop instead of a Do While.

Are you setting your variables (strCoName, strConName, strAddress, strCity, strState, strZip, etc.) before the loop with the info for the first company?