How to link 2 files so that only non-matching records will display 3

[ewarr]

I need to link 2 files together and only display the "new" resellers that were not in the Master Reseller file. This report will be used to capture the non-matching records only. I can't figure out the correct linking to do this.

File 1 = Master Resellers File
File 2 = Daily Resellers (this file may include new resellers that were not in the Master Resellers File)

I only want to display the "new" resellers.

Fields:
Reseller IC#
Reseller Name
Reseller City
Reseller State

Same fields are in both files. Can anyone help? I've tried every linking scenario...Thanks!

 

[Turkbear]

Hi,
Depending on your database ( and link options) try a NOT EQUAL link between Daily ----> Master on IC#, this should show only those Daily resellers NOT in Master.

Perhaps a better way would be to create the report from a Command like:

Select * from Daily
MINUS
Select * from Master

This will leave only those in Daily Only in the dataset.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ewarr]

I tried this and it still doesn't work. Do I use inner or outer join? Enforced, not enforced? Does the link point to the Master file or Daily file?

 

[Turkbear]

Hi,
I would try the Command option, but to use linking
As I indicated,link From Daily to Master, then set the Link type to != ( or <>) - Enforced



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

You could also use a left join FROM Daily Resellers TO Master Resellers, and use a record selection formula of:

isnull({MasterResellers.ID#})

-LB

 

[jmd0252]

changing the join type would be the best option, if you do not know about "joins",, google it, will give you good info.

 

[ewarr]

lbass - I tried your approach and it worked great! Thanks!