Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rmduser

  1. rmduser

    Sum with exclusion condition

    Thanks very much for your advice!
  2. rmduser

    Sum with exclusion condition

    I am using CR7 MR1. I want to create a formula to sum a field but exclude values where another field meets a certain condition. It would look like: sum {pay_detl.total} where {pay_detl.location}<>MSMIS I know that there is no "where" function in CR (unlike SQL) so I'd appreciate your advice...
  3. rmduser

    Retrieving Constant Data from One Record

    Thanks very much, Ken. It works perfectly!
  4. rmduser

    Retrieving Constant Data from One Record

    Yes, the source database is only 4 records with 4 fields: Contract No., CertificateID, Acct No. and Total. The &quot;general&quot; Acct No., whose total I want distributed, is a string identified by 5 zeros at the front on the string.
  5. rmduser

    Retrieving Constant Data from One Record

    I have a CR 7.0 report to generate a payment certificate. The report has a cost distribution subreport which uses a application-generated local .db table. The .db table has totals for 3 accounts plus the first record always has a total that must be distributed proportionally into the 3 other...
See more

Part and Inventory Search

Back
Top