Henry,

Use parenthesises to correctly group your conditions for AND and OR.

>Hi all:
>
>I have the following code:
>
>

SELECT services.feesubmit,.................... ;
>		from services ;
>		into cursor unpaids nofilter ;
>		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

>
>
>Current Outcome: Shows both under and over payments.
>
>Desired Outcome: Only negative variances should be selected. Underpayments only.
>
>Where am I going wrong in the logic of the select statement? Thanks in advance.