<i><b>Originally posted by : ckinner (webmaster@judson-il.edu)</b></i><br />I am hoping someone can help here.<br /><br />Here is the basic sql code... <br />==========================<br />SQLStmt = "SELECT fullname, vmail,id_rec.id, addr_line1, addr_line2, city, st, zip, phone, pos, txt, bus_ext, priv_code "<br />SQLStmt = SQLStmt & "FROM id_rec, emp_rec, profile_rec, outer ofc_table "<br />SQLStmt = SQLStmt & "WHERE fullname = '" & fullname & "' " <br />SQLStmt = SQLStmt & "AND id_rec.id = profile_rec.id "<br />SQLStmt = SQLStmt & "AND id_rec.id = emp_rec.id "<br />SQLStmt = SQLStmt & "AND ofc_table.ofc = emp_rec.bus_dept "<br />SQLStmt = SQLStmt & "AND (end_date is null) "<br />SQLStmt = SQLStmt & "AND bus_id = 100 "<br />SQLStmt = SQLStmt & "ORDER BY fullname "<br />Set RS = objDC.Execute(SQLStmt)<br />======================<br />everything works fine except for the id<br />I am using the command <br />=====================<br /><%= RS("fullname") %><br />====================<br />to pull data into the html form<br />the only one that doesn't work is<br />===============================<br /><%= RS("id") %><br />===================<br />Thanks for any help here.<br />