RE: [MS_AccessPros] Distinct Values

Looks good from here. Perhaps you can provide more details about your results.

Duane

To: MS_Access_Professionals@yahoogroups.com
From: jlinux@comcast.net
Date: Tue, 27 Dec 2011 17:14:40 +0000
Subject: [MS_AccessPros] Distinct Values

I have this Select statement on a form:

SELECT [tbl_Items].[ItemsID], [tbl_Items].[BoxNumber] FROM tbl_Items ORDER BY [BoxNumber];

How would I return just the Distinct or Unique values? I selected 'Yes' on Unique Values on the Query property sheet, but that did not work. I also tried this:

SELECT DISTINCT [tbl_Items].[ItemsID], [tbl_Items].[BoxNumber] FROM tbl_Items ORDER BY [BoxNumber];

But that didn't work either. Can someone please point me in the right direction?

Thanks,

John

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/