Hi Henry

You should break yourself of the habit of using .and. and .or.. They are not SQL standards and VFP doesn't need this archaic referencing anymore.

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