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

Welcome Guest ( Log In | Register )

> Filter To List One Name From A Table Of Multiple Entries For Each Name., Office 2010    
 
   
dwhite913
post Mar 2 2012, 11:03 AM
Post #1

New Member
Posts: 5
I have a table with multiple entries of the same name. How can I query the table and just list the name once?
Go to the top of the page
 
+
 
 Start new topic
Replies (1 - 1)
theDBguy
post Mar 2 2012, 11:07 AM
Post #2

Access Wiki and Forums Moderator
Posts: 48,019
From: SoCal, USA
Hi,

(IMG:style_emoticons/default/welcome2UA.gif)

You can try using the DISTINCT keyword in your query. For example:

SELECT DISTINCT FieldName FROM TableName ORDER BY FieldName;

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)
Go to the top of the page
 
+
« Next Oldest · Other Database Engines · Next Newest »
 

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

Jump To Forum:
 

Display Mode: Switch to: Standard · Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 08:44 PM