Prev: Query for two fields in one record that do not match
Next: Want a counter for Access Query results
From: puppypaws on 30 Jun 2008 11:45
I'm working with a huge imported database from which I needa query with
employee id, last name, first name, benefit name employee cost and employer
cost. I keep getting duplicates on the ID and names. How can I get rid of
these so that the employee number is the key record?
From: scubadiver on 30 Jun 2008 11:54

Why not use distinct?

Select distinct ......
from ....

"puppypaws" wrote:

> I'm working with a huge imported database from which I needa query with
> employee id, last name, first name, benefit name employee cost and employer
> cost. I keep getting duplicates on the ID and names. How can I get rid of
> these so that the employee number is the key record?
From: adam.vogg on 30 Jun 2008 11:54
setup an empty table with the employee ID set as primary key. then
change your query into an append query and append into that table.
you will get a warning saying "cant append X number of records due to
primary key violation". those are your dupes not being entered. the
table will then have your records with no duplicates.
From: puppypaws on 30 Jun 2008 11:59
I'm not very experienced with this. I've tried "first" and " no duplicates"
but it takes away everything. Do I just type "distinct" in the criteria box?

"scubadiver" wrote:

>
> Why not use distinct?
>
> Select distinct ......
> from ....
>
> "puppypaws" wrote:
>
> > I'm working with a huge imported database from which I needa query with
> > employee id, last name, first name, benefit name employee cost and employer
> > cost. I keep getting duplicates on the ID and names. How can I get rid of
> > these so that the employee number is the key record?
From: puppypaws on 30 Jun 2008 12:02
Thanks! I'll give it a try!

"adam.vogg(a)gmail.com" wrote:

> setup an empty table with the employee ID set as primary key. then
> change your query into an append query and append into that table.
> you will get a warning saying "cant append X number of records due to
> primary key violation". those are your dupes not being entered. the
> table will then have your records with no duplicates.
>
 |  Next  |  Last
Pages: 1 2
Prev: Query for two fields in one record that do not match
Next: Want a counter for Access Query results