Problem w/Query results, some dups, one missing

[rebfein]

I have come across an issue that I can't fix at this time; regarding a query from a database I've created for my boss. The db was created to keep track of parts and manufactures that are active, inactive or obsolete. I've created queries for many things and they've all worked fine, except for one; the query that sums it all up at a glance for my boss. I even went so far as to create a separate table just for him for this situation, but it is getting harder to avoid double entries; so I created the query for him instead. However, it is not working properly, as it is duplicating information for just two parts

FYI: We can have up to 7 different manufacturers for each part; so I created 7 P/N tables to reflect this.

My boss' query involves 9 tables (the 1st is for the part's category; the 2nd is a description of each part; and the other 7 are all the P/N Mfr. tables ).


When I run the query, every thing was fine except for two part numbers:



This query shows one extra repeating row of information for P/N DR30064 and up to 124 repeating rows of P/N DR30065.

I went through the tables and deleted 3 rows of duplicate data; then I re-ran the query.

Table 1 Table 2

As you can see, the query still duplicated P/N DR30064 one time and does NOT show anything about P/N DR30065! I just want to output a list for my boss to look at a glance.

For the past 2 years, you've all helped me when I was thrown into a situation of creating a part management db system w/out knowing ANYTHING about Access. And for your unwavering assistance, I am truly grateful. I also hope you can help me now.

With thanks, Rebecca

[ranman256]

Because of your joins and data entries, you may get duplicates.
If you dont want dupes, you can set the query to UNIQUE VALUES = TRUE.

IF you need missing items, you will need an outer join.