Gowey Mike W
Mike.W.Gowey at doc.state.or.us
Thu Jun 9 12:34:53 CDT 2005
I want to be able to display the value of the following select statement on a form. It should only find one tag number since I do not allow duplicates. I want to be able to see the results on the form. strSQL = "SELECT DISTINCT tblInventory.[DOC Tag Number+] FROM tblInventory " strSQL = strSQL & " WHERE tblInventory.[DOC Tag Number+] = '" & Tag & "'" strSQL = strSQL & " ORDER BY tblInventory.[DOC Tag Number+];" Thanks in advance for any advice. Mike Gowey MCDST, A+, LME, NET+ Team Leader - East Region Information Systems Unit