<p>All, I need help.</p>
<p> </p>
<p>We have a report that shows services provided for clients and the authorization (Auth) code for the services.</p>
<p>I'm trying to update the report to also show selected fields if the services were not provided under the authorization codes that exist for the client. Our goal is to determine where services are being provided that we aren't getting paid for (because they are not authorized). There is a challenge in that each client has his/her own Auth codes and there can be more than one for any given client.</p>
<p> </p>
<p>How do I code to pull in all auth codes and then look through that list to check records NOT IN that list?</p>
<p> </p>
<p>Thank you kindly for any help you can provide!</p>
<p> </p>
<p>D,</p>
<p> </p>
