UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> query duplicate fields, but show each only once.    
 
   
RFree190
post Jan 30 2007, 11:07 PM
Post #1

UtterAccess Addict
Posts: 242
From: Southern California



I am trying to come up with a query to show duplicates in a table, but show each duplicate only once. Is this doable???? The duplicate field I am trying to show are ZipCodes. I would like a list of each of the Zip Codes used in my table, but show them only once each.
Go to the top of the page
 
+
jwhite
post Jan 30 2007, 11:16 PM
Post #2

UtterAccess VIP
Posts: 5,215
From: North Carolina, USA



With the query in Design View:

Position the Mouse anywhere in the top area where the tables are shown, Rt-Click to show the Query Properties.
Change "Unique Values" to YES. After making the change, you will notice that the SQL View will now show the word "DISTINCT" right after "SELECT". You could have switched to SQL View and manually typed in the word, but showed the other way in case you weren't aware of it.

HTH


--------------------
Go to the top of the page
 
+
RFree190
post Jan 30 2007, 11:21 PM
Post #3

UtterAccess Addict
Posts: 242
From: Southern California



Thanks John! Works great.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 23rd July 2014 - 01:03 PM