Only Once

Trying to get a list of items to appear only once. I got the query to work,
but it lists dups.

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.

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.

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]

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.