I am having a hard time trying to display the last user who modified the record including the date. Any ideas? HEre is what I have so far.

        <td>

            <%
              Dim mySQL, objRS, createdByMsg, auditreason

              Set objRS = Server.CreateObject("ADODB.Recordset")

              mySQL = "SELECT * FROM ConAdmPSAAgreementsAudit" & _
                   " where agreement_no ='" & strAgreementNum & "'"

              'mySQL = "Select * from ConAdmPSAAgreementsAudit where auditreason = '" & auditreason & "' select *, '" & session("username") & "', getdate(), " & _
                  '"'TEST'" & "' from ConAdmPSAAgreements(nolock) where agreement_no = '" & strAgreementNum & "'"
              'response.write mySQL & "<br>"
              'response.end

              objRS.Open mySQL, cn

              if objRS.eof then
                response.write "NO RECORDS ADDED/UPDATED"
              elseif objRS.fields("auditreason") = "AFTERINSERT" or objRS.fields("auditreason") = "AFTERUPDATE" then
                createdByMsg = iif(isnull(objRS("auditUserID")), objRS("auditreason"), " Record was " & objRS("auditreason") & " on " & objRS("auditdate") & " by " & GetUserName(objRS("auditUserID")))
              end if
            %>
                <b><%=createdByMsg%></b>

         </td>

Any help is appreciated. :D

Ummmm...what is the error???? If any?

VBScript doesn't *HAVE* an IIF( ) function built in. You can easily create one, but if you didn't do so then for sure your use of IIF( ) in that code would cause an error.

When you don't say WHAT doesn't work and/or tell use what the error is, it's anybody's guess.

One major question: Will there ever be more than one record returned from the query???? If so, you have no code at all in there to account for that.