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.