<% oConn.Open(sConnString) 'This opens the database. %> <% Dim Results Results = Request.Form("LastNames") Response.Write Results Set rConn = oConn.Execute("SELECT * FROM Table1 WHERE LastName = '"& Results &"'") %>

<%=rConn.Fields("ID").Value%>

<%=rConn.Fields("LastName").Value%>

<%=rConn.Fields("FirstName").Value%>

<%=rConn.Fields("Major").Value%>

<%=rConn.Fields("Year").Value%>

<%=rConn.Fields("GPA").Value%>