Page 1 of 1
Exception Report
Posted: Wed Mar 06, 2002 11:33 pm
by PTan
[updated:LAST EDITED ON Mar-06-02 AT 11:34 PM (EST)]How do I create an exception report?____For example, File A has 20 records. File B has 5 records. Both File A & File B have a common field. File A has 5 records exactly the same as File B. How can I print out the 15 records in File A that are different than File B? Is it possible?____Thanks in advance.__
=> RE: Exception Report
Posted: Thu Mar 07, 2002 5:51 am
by kfleming
You need to make File A the master file and then set a relation to file B using blank as the failure action.____Then query for fileA->linkfield <> fileB->matchingfield____and you will see all the A records that have no matching B record.____Kathleen__R&R Support
==> RE: Exception Report
Posted: Thu Mar 07, 2002 9:43 am
by PTan
Thank you for your prompt response. I was under the impression that you can^t use fields in the "Compared To:" area of the query.____Tried it, it worked, and thanks again.__:-)