dups in a query

[Guest]

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"

 

[Duane Hookom]

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

 

[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

 

[Marshall Barton]

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?

 

[Guest]

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..

 

[Duane Hookom]

No sense of humor today? I guess I forgot the ;-)

 

[Guest]

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

 

[Guest]

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"

 

[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.

 

[Guest]

Trust me - you don't upset me!!

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.