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

>
>>
>>

paid = YES
>>billed = YES
>>closeclaim =
>>claim_no = 0
>>invoice_no = 1
>>amt_paid = 330.00
>>feesubmit = 24.00
>>feesubmit1 = 22.00
>>feesubmit2 = 37.50
>>feesubmit3 = 248.00
>>feesubmit4 = 0.00
>>feesubmit5 = 0.00
>>feesubmit6 = 0.00
>>

>>>