dups in a query

I ran across this solution when looking for ways to eliminate dups in a query
I'm creating...The SELECT DISTINCT option seems like the answer for me, but
I'm not familiar with code in Access...can someone simplify this for me and
tell me where in the SQL view I should enter this text? Thanks so much!



I feel so stupid - I forgot about DISTINCT...
Thanks

"Marshall Barton" wrote:

Dan @BCBS wrote:

Can I add a simple statement to a query to eliminate duplicates, without
having to create a new query without making a new "Find Duplicates Query".
example: Criteria = "no dups"


No such criteria, but maybe

SELECT DISTINCT . . .

will do what you want?

--
Marsh
MVP [MS Access]

Open up the query in design view. Go to View then SQL View. Place the word
DISTINCT right after SELECT.

Another option is to open up the query in design view. Go to View then
Totals. By default Access will Group By all fields which is all but the same
as adding the DISTINCT.

Personally I like adding the DISTINCT better. Makes for cleaner looking SQL.
However you don't see the DISTINCT in the QBE grid so Totals has an advantage
when trying to find out why there aren't as many records as you think.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"bejewell" wrote:

I ran across this solution when looking for ways to eliminate dups in a query
I'm creating...The SELECT DISTINCT option seems like the answer for me, but
I'm not familiar with code in Access...can someone simplify this for me and
tell me where in the SQL view I should enter this text? Thanks so much!



I feel so stupid - I forgot about DISTINCT...
Thanks

"Marshall Barton" wrote:

Dan @BCBS wrote:

Can I add a simple statement to a query to eliminate duplicates, without
having to create a new query without making a new "Find Duplicates Query".
example: Criteria = "no dups"


No such criteria, but maybe

SELECT DISTINCT . . .

will do what you want?

--
Marsh
MVP [MS Access]

Thank you so much!!

"Jerry Whittle" wrote:

Open up the query in design view. Go to View then SQL View. Place the word
DISTINCT right after SELECT.

Another option is to open up the query in design view. Go to View then
Totals. By default Access will Group By all fields which is all but the same
as adding the DISTINCT.

Personally I like adding the DISTINCT better. Makes for cleaner looking SQL.
However you don't see the DISTINCT in the QBE grid so Totals has an advantage
when trying to find out why there aren't as many records as you think.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"bejewell" wrote:

I ran across this solution when looking for ways to eliminate dups in a query
I'm creating...The SELECT DISTINCT option seems like the answer for me, but
I'm not familiar with code in Access...can someone simplify this for me and
tell me where in the SQL view I should enter this text? Thanks so much!



I feel so stupid - I forgot about DISTINCT...
Thanks

"Marshall Barton" wrote:

Dan @BCBS wrote:

Can I add a simple statement to a query to eliminate duplicates, without
having to create a new query without making a new "Find Duplicates Query".
example: Criteria = "no dups"


No such criteria, but maybe

SELECT DISTINCT . . .

will do what you want?

--
Marsh
MVP [MS Access]

On Fri, 3 Mar 2006 09:01:34 -0800, Jerry Whittle
wrote:

Open up the query in design view. Go to View then SQL View. Place the word
DISTINCT right after SELECT.

or, equivalently, view the Query's Properties and set the "Unique
Values" property to Yes.

John W. Vinson[MVP]