>>>If paid = "YES", your select won't select it...
>>
>>OK - but CloseClaim <> YES , Invoice_No is > 0 and amt_paid is < the sum of all feesubmits. All the other conditions are valid.
>>
>
>You have AND after paid <> "YES". If paid = "YES", nothing after that point matters (and the rest of the stuff is not even evaluated).
>
>
>
>where services.paid <> "YES" .AND. ;
> services.billed ="YES" .and.;
>
>
Steve: My logic was:
1. a service should 1st be billed
2. a service should have been paid (not necessarily the amount billed)
3. it could be either a claim_no or an invoice_no
4. the record or claim should not have been close out (Closeclaim)
Idea is to get a list of all underpayments ONLY whereever a bill has been generated with a claim_no or an Invoice_no. After that the user may Close the calim, which would then update CloseClaim to YES.
How do you suggest I go about this. Thanks.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons