No dublicates

[ChristopherL]

Hi there!
I am having some trouble with a query, I'm gonna try to put this out as good as possible

I have linked two tables together in a query. Each row in the column [Trunc_Name] is so suppose to be unique, but my query put out dublicates for some Trunc_Name's. Almost all duplicates(that are not suppose to be there) have value= Null.

So to get those duplicates out I did

is not Null

and that worked perfectly.

However, some Trunc_Names that are not duplicates contain Null as a value! So what I want to do is to remove Trunc_Names that are duplicate with null values, and keep the Unique Trunc_Names (only of these exist) with null value..

Sorry for bad explanation, tried my bst! :banghead:

 

[plog]

Post sample data from each table, the names of all tables and fields and then what you expect back from your query based on that sample data.

Use this format for posting data:

Table1NameHere
Field1NameHere, Field2NameHere, Field3NameHere
David, 14, 4/3/2007
Sally, 2, 2/28/2003
Jim, 44, 11/10/2009