dups in a query

D

Dan @BCBS

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"
 
D

Duane Hookom

I think the only simpler method (other than the find dups query) is to have
someone else do it.
 
M

Michel Walsh

Hi,



Build an index on the table (on multiple field, if required) and have that
index not allowing duplicated values.


If you already have data with duplicated values, insert it in the previous
table. You will get errors about some records not being appended, that is
normal, those are the dup. After the insertion, the first table I mentioned
would hold your data without dup.


Hoping it may help,
Vanderghast, Access MVP
 
M

Marshall Barton

Dan @BCBS said:
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"
Click to expand...


No such criteria, but maybe

SELECT DISTINCT . . .

will do what you want?
 
D

Dan @BCBS

I'll take that as a no.
I have many very complicated queries that need the duplicates extracted.
I wrote Microsoft support in hopes to get a somewhat responsible answer -
not to have someone tell me to "get someone else to do it"..

You are in the wrong job..
 
D

Dan @BCBS

I've had two other replays, which answered my question and saved me a great
deal of time.

Some people actually have to work for a living, maybe you should find a job
you can handle.. "not a joke"
 
D

Duane Hookom

Sorry to have upset you.
I hope you are having a better day and your co-workers don't try to lighten
up any of your meetings/discussions.
 
D

Dan @BCBS

Trust me - you don't upset me!!

Duane Hookom said:
Sorry to have upset you.
I hope you are having a better day and your co-workers don't try to lighten
up any of your meetings/discussions.
Click to expand...
 
Top