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

Welcome to UtterAccess! Please ( Login   or   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



Posts: 254
Joined: 18-December 06
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,250
Joined: 31-August 06
From: North Carolina, USA


With the query in Design View:
osition 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



Posts: 254
Joined: 18-December 06
From: Southern California


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


RSSSearch   Top   Lo-Fi    1st March 2015 - 01:50 AM