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!

Search results for query: *

  • Users: RevItUp
  • Content: Threads
  • Order by date
  1. RevItUp

    Sum function ignoring some records

    I am using Ver.8. against an Oracle DB (Remedy ODBC) I have 2 fields defined to enable me to sum the qty of records based some conditions: FieldName1: If FIELD-A = VALUE-1 or VALUE-2 or Field-B = VALUE-3 or VALUE-4 then 1 else 0. FieldName2: If FieldName1 = 0 then 1 else 0. The 2nd...
  2. RevItUp

    Accessing multiple db reports from CE/ePortfolio-CE8

    I've always accessed only my Remedy database with CR from CE but now I want to run a report that hits an Access database. I have the same ID/password setup in Access, CE, and the ODBC data source but the Viewer still rejects the ID/password. The Access database is on the same server and I can...
  3. RevItUp

    Convert seconds to HH:MM:SS

    Is there a straight forward way to convert seconds to Hours, Minutes, Seconds? For example 3729 seconds to 1:02:09. I have a line item that's already an average number of seconds based on a number of phone calls. To summarize it I must first multiply the the avg seconds by the number of calls...
  4. RevItUp

    Group Count as a % of Total Records

    I'm doing running totals of groups and would like to display the percent of the total number of records for each group: group 1 30 15% group 2 100 50% group 3 70 35% --- Ttl recs 200 How do I do the calculation to get...

Part and Inventory Search

Back
Top