>Meaning you can't? hehe. I don't want to see any sensitive information. :)
>
>I'm just curious about the following fields: paid, billed, closeclaim, and the end result of the fees calculation.
>

Sorry Steve. I got you all wrong. I interpreted as though you were asking me if that record showed up. Here's the entire select statement.

	SELECT services.feesubmit,services.feesubmit1,services.feesubmit2,;
		services.feesubmit3,services.feesubmit4,services.feesubmit5,;
		feesubmit6 , amt_paid,claim_no,paid,hlth_card,pat_name,;
		diag_code,date_serv,premium,ALLTRIM(feecode)+" "+ALLTRIM(feecode1)+" "+;
		ALLTRIM(feecode2)+" "+ALLTRIM(feecode3)+" "+;
		ALLTRIM(feecode4)+" "+ALLTRIM(feecode5)+" "+ALLTRIM(feecode6) as Codes,;
		bill_date,lcl_doc_nm,lcl_docnam, Invoice_no ;
		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

The resulsts are on a report, not sure how I could copy that and paste it on here. Sorry about the confusion.