Duplicate Records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Metalteck - 11 May 2005 21:28 GMT

I create a query and when I generate it, it pulls nearly 17,000 records.
After sifting through the records, there are only about 100 files, but is
duplicated 100 times. Is there anything I can do to eliminate the duplication?

Reply to this Message

Douglas J. Steele - 11 May 2005 22:25 GMT

Sounds as though your query has more than one table involved, and you're
getting a cross-product.

Post more details, and someone should be able to help you.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I create a query and when I generate it, it pulls nearly 17,000 records.
> After sifting through the records, there are only about 100 files, but is
> duplicated 100 times. Is there anything I can do to eliminate the
> duplication?

Reply to this Message

Ofer - 11 May 2005 22:34 GMT

Add distinct in your query

SELECT distinct Field1,Field2
FROM MyTable

> I create a query and when I generate it, it pulls nearly 17,000 records.
> After sifting through the records, there are only about 100 files, but is
> duplicated 100 times. Is there anything I can do to eliminate the duplication?

Reply to this Message