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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kpetree

    Macola ES last check number used

    The last check number is stored in the 'settings' table. Look in the 'settinggroup' field for 'macola_last_check'. You may see multiple entries if there is multiple bank accounts.
  2. kpetree

    Union with Null values

    Sorry, the title meant to say "Join with null values" I started with a union and changed it back to this.
  3. kpetree

    Union with Null values

    I've got two tables. bmprdstr_sql is an item bill of material table and imordbld_sql is the bill of material attached to an order. I'm working on a query that will show me what items were a part of the original bill of material that are not part of the BOM attached to the order. My thought is to...
  4. kpetree

    Remove suppressed values from running total

    lbass, you are awesome, thank you!
  5. kpetree

    Remove suppressed values from running total

    I have a suppression formula on the detail row that looks like this... Previous({mctrxhst_sql.ord_no})={mctrxhst_sql.ord_no} and Previous({mccrwhst_sql.oper_no})={mccrwhst_sql.oper_no} and Previous({mctrxhst_sql.trx_dt})={mctrxhst_sql.trx_dt} and...
  6. kpetree

    Remove supressed record from total

    Thanks LB, that worked!
  7. kpetree

    Remove supressed record from total

    I'm using Crystal 10 and I have a report that shows invoices due and totals them up. In the case of a duplicate invoice number is supresses the record but it still counts the supressed record in the total. How can I make the total not count the supressed records? Thanks!

Part and Inventory Search

Back
Top