query question

[smithrd6]

I am attempting to link two tables. The second table contains company name unique to a company code contained in table one. Not every entry in table one has the information but I wanted to include it when it does. The first table has 31 rows of information. When I run the query is duplicating records on the order of from 31 original to over 1400. How can I eliminate the duplicates?

thanks

 

[xenou]

Could you post your query?

Sometimes simply adding the Keyword DISTINCT is all you need. I.e., in SQL view:

SELECT DISTINCT table1.companycode, table2.companyname...

This is also available in access by setting query properties | unique values to yes.

 

[giacomo]

Are you creating a join between the 2 tables in your query? If you try to query two tables without a join the result is the product of those tables, kind of sounds like what you're describing.

hth,
Giacomo