Problem with SQL generated from Access on an ASP page

The following SQL code does not return anything to the Full_Name fields when the ASP page tries to display it in a table.

SELECT TestLabMasterTable.Test_Request_Number, TestLabMasterTable.Description, TestLabMasterTable.Percent_Complete, EmployeeTable.Full_Name, TestLabMasterTable.Priority_Code, TestLabMasterTable.Date_Submitted, TestLabMasterTable.Date_Requested_Completion, TestLabMasterTable.Date_Promised_Completion, TestLabMasterTable.Date_Samples_Promised, TestLabMasterTable.Date_Samples_Delivered, TestLabMasterTable.Date_Actual_Completion, TestLabMasterTable.Date_Report_Distributed, EmployeeTable_1.Full_Name
FROM (TestLabMasterTable LEFT JOIN EmployeeTable ON TestLabMasterTable.Assigned_ToEID = EmployeeTable.EID) LEFT JOIN EmployeeTable AS EmployeeTable_1 ON TestLabMasterTable.Requested_ByEID = EmployeeTable_1.EID
WHERE (((TestLabMasterTable.Percent_Complete)<100) AND ((TestLabMasterTable.Cancelled)<>Yes))
ORDER BY TestLabMasterTable.Test_Request_Number;

This is generated by Access via the Export to ASP utility.

Here is what the ASP tries to display;

On Error Resume Next
rs.MoveFirst
do while Not rs.eof
%>
<TR VALIGN=TOP>
<TD BORDERCOLOR=#c0c0c0 ><FONT SIZE=2 FACE="Arial" COLOR=#000000><%=Server.HTMLEncode(rs.Fields("Test_Request_Number").Value)%><BR></FONT></TD>
<TD BORDERCOLOR=#c0c0c0 ><FONT SIZE=2 FACE="Arial" COLOR=#000000><%=Server.HTMLEncode(rs.Fields("Description").Value)%><BR></FONT></TD>
<TD BORDERCOLOR=#c0c0c0 ALIGN=RIGHT><FONT SIZE=2 FACE="Arial" COLOR=#000000><%=Server.HTMLEncode(rs.Fields("Percent_Complete").Value)%><BR></FONT></TD>
<TD BORDERCOLOR=#c0c0c0 ><FONT SIZE=2 FACE="Arial" COLOR=#000000><%=Server.HTMLEncode(rs.Fields("EmployeeTable.Full_Name").Value)%><BR></FONT></TD>
<TD BORDERCOLOR=#c0c0c0 ><FONT SIZE=2 FACE="Arial" COLOR=#000000><%=Server.HTMLEncode(rs.Fields("Priority_Code").Value)%><BR></FONT></TD>
<TD BORDERCOLOR=#c0c0c0 ALIGN=RIGHT><FONT SIZE=2 FACE="Arial" COLOR=#000000><%=Server.HTMLEncode(rs.Fields("Date_Submitted").Value)%><BR></FONT></TD>
<TD BORDERCOLOR=#c0c0c0 ALIGN=RIGHT><FONT SIZE=2 FACE="Arial" COLOR=#000000><%=Server.HTMLEncode(rs.Fields("Date_Requested_Completion").Value)%><BR></FONT></TD>
<TD BORDERCOLOR=#c0c0c0 ALIGN=RIGHT><FONT SIZE=2 FACE="Arial" COLOR=#000000><%=Server.HTMLEncode(rs.Fields("Date_Promised_Completion").Value)%><BR></FONT></TD>
<TD BORDERCOLOR=#c0c0c0 ALIGN=RIGHT><FONT SIZE=2 FACE="Arial" COLOR=#000000><%=Server.HTMLEncode(rs.Fields("Date_Samples_Promised").Value)%><BR></FONT></TD>
<TD BORDERCOLOR=#c0c0c0 ALIGN=RIGHT><FONT SIZE=2 FACE="Arial" COLOR=#000000><%=Server.HTMLEncode(rs.Fields("Date_Samples_Delivered").Value)%><BR></FONT></TD>
<TD BORDERCOLOR=#c0c0c0 ALIGN=RIGHT><FONT SIZE=2 FACE="Arial" COLOR=#000000><%=Server.HTMLEncode(rs.Fields("Date_Actual_Completion").Value)%><BR></FONT></TD>
<TD BORDERCOLOR=#c0c0c0 ALIGN=RIGHT><FONT SIZE=2 FACE="Arial" COLOR=#000000><%=Server.HTMLEncode(rs.Fields("Date_Report_Distributed").Value)%><BR></FONT></TD>
<TD BORDERCOLOR=#c0c0c0 ><FONT SIZE=2 FACE="Arial" COLOR=#000000><%=Server.HTMLEncode(rs.Fields("EmployeeTable_1.Full_Name").Value)%><BR></FONT></TD>

</TR>
<%
rs.MoveNext
loop%>

Any help? I think it is in the AS clause.

Try rs.fields("EmployeeTable_1.Full_Name")

or, in the select clause use EmployeeTable.Full_Name AS Full_Name and just pull rs.fields("Full_Name")

Hope this helps