[AccessD] Value Retrieval

Gowey Mike W Mike.W.Gowey at doc.state.or.us
Thu Jun 9 12:46:09 CDT 2005


I'm wondering if someone can get me out of my brain freeze:

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





More information about the AccessD mailing list