If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Only Once
Trying to get a list of items to appear only once. I got the query to work,
but it lists dups. |
#2
|
|||
|
|||
Only Once
So? What is your question?
What is the SQL of your query? -- Build a little, test a little. "Sylvia1968" wrote: Trying to get a list of items to appear only once. I got the query to work, but it lists dups. |
#3
|
|||
|
|||
Only Once
It kind of depends on what you mean by dups.
It could be as simple as changing the query by adding the Distinct predicate. In query design view, set the queries Unique Values property to yes. == open query in design view == select View: Properties from the menu == Click on a blank area of the top section that displays the tables == Change Unique Values to Yes IN SQL view, add the word DISTINCT after the word SELECT SELECT DISTINCT SomeField FROM SomeTable ORDER BY SomeField John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Sylvia1968 wrote: Trying to get a list of items to appear only once. I got the query to work, but it lists dups. |
#4
|
|||
|
|||
Only Once
On Sun, 21 Feb 2010 11:44:01 -0800, Sylvia1968
wrote: Trying to get a list of items to appear only once. I got the query to work, but it lists dups. Correct the error in your query. If you would like help doing so, please post a description of the table and open your query in SQL view and post the SQL text here... we can't fix what we can't see! -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Only Once
Maybe like this --
SELECT YourTable.*, Count([SomeField]) AS CountOfSomeField FROM YourTable WHERE Count([SomeField]) =1; -- Build a little, test a little. "KARL DEWEY" wrote: So? What is your question? What is the SQL of your query? -- Build a little, test a little. "Sylvia1968" wrote: Trying to get a list of items to appear only once. I got the query to work, but it lists dups. |
Thread Tools | |
Display Modes | |
|
|