Exception Report

[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.__

[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

[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.__:-)