MS Access 2000
I have 2 tables “MDW” and “LeadList”
Each table contains the same type of data (Contact information)
Some duplicate records MAY be in both tables.. (I would like to ignore the dupes).
Each table has a unique ID field but are in no way related
I need to create a 3rd table “NewTable” WHERE…
MDW!FirstName is not = to LeadList!FirstName
And
MDW!LastName is not equal to LeadList!LName
And
…….. I need to look at 10 fields
My thought was to create a query with both tables. Create Joins (where both are equal) for all 10 fields and moving on from there. The fields may or may not have values. I don't think I could add records if only of the indexed fields are null... Can I?
Does anybody see me walking in front of a freight train? Or, any other ideas?
TIA
Detrie
I have 2 tables “MDW” and “LeadList”
Each table contains the same type of data (Contact information)
Some duplicate records MAY be in both tables.. (I would like to ignore the dupes).
Each table has a unique ID field but are in no way related
I need to create a 3rd table “NewTable” WHERE…
MDW!FirstName is not = to LeadList!FirstName
And
MDW!LastName is not equal to LeadList!LName
And
…….. I need to look at 10 fields
My thought was to create a query with both tables. Create Joins (where both are equal) for all 10 fields and moving on from there. The fields may or may not have values. I don't think I could add records if only of the indexed fields are null... Can I?
Does anybody see me walking in front of a freight train? Or, any other ideas?
TIA
Detrie
