>Can you show all of the values for the fields (at least for all the fields in the WHEN clause) for this record that did not show up?
>
Hi Steve:

Good to hear from you. The answer is No. The record which has no claim_no but has an invoice_no did not show up in the report.


>>Sergey:
>>
>>I ran into another problem. Heres the ammended section of the select statement:
>>
>>

where services.paid <> "YES" .AND. ;
>>			services.billed ="YES"  .and.;
>>			(services.claim_no > 0 .or. ;
>>			services.invoice_no > 0) .and.;
>>			services.closeclaim <> "YES" .and.;
>>			(services.amt_paid - (services.feesubmit+services.feesubmit1+services.feesubmit2+;
>>		services.feesubmit3+services.feesubmit4+services.feesubmit5+;
>>		feesubmit6)) < 0

>>
>>The paranthesis are on claim_no or invoice_no. This took care of showing only the underpayments, butONLY for those with claim_no and did not include a record where the claim_no was empyt but the invoice_no was greater than 0.
>>
>>What should I do? Thank you.