Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select Statement
Message
From
07/03/2003 16:18:16
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00762981
Message ID:
00763013
Views:
17
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.
- Ravi

True greatness consists in being great in little things.
- Charles Simmons
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform