[AccessD] Access on Macs

Are you sure you have the right subject on this post?

Charlotte Foust


-----Original Message-----
From: Gowey Mike W [mailto:Mike.W.Gowey at doc.state.or.us] 
Sent: Thursday, June 09, 2005 10:35 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Access on Macs


 
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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com