Hello Ravi,

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?

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