>>Is the paid flag relevant at all?
>Reviewing the requirement, it appears that "Paid" may no longer be relevant.
>
>It is important that billed = YES , becuase this is set to YES only when a claim_no has been generated. The next one is that it could either be a claim_no or an invoice_no. CloseClaims becomes important, becuase if this field is an YES , then the record should not be selected.. Will the last part of the select statement (where it totals the feesubmits and checks to see if the submitted amount is greater than the amt_Paid? i.e. If its an overpayment, I don;t want it to be selected, even if CloseClaim <> YES.
>

You can probably omit either the billed = "YES" check, or the (claim_no > 0 or invoice_no > 0). It looks like they are checking for the same thing. I say this because billed is YES only if a claim_no (or and invoice_no) has been generated.

>>
>The guys who originally worked on this part was quite confused with the .T. and .F. switches, therefore the YES or blank strategy.

hmmm...I'd probably be changing that back...