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 derfloh 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 dwcats67

  1. dwcats67

    Selecting specific info from mostly similar records

    lbass, Your advice was just what I needed. I'd been trying running totals, and the idea of evaluating on change of field just escaped me for some reason (hiding in plain sight). Thank you! Thank you, too, synapsevampire. I also appreciate your advice. dwcats67
  2. dwcats67

    Selecting specific info from mostly similar records

    I apologize for the delay in getting back to you. My intention is to sum the information from each first line that I have indicated with a * (count is not needed). Here is a more detailed example with info that may be more helpful to you: {field.agent} {field.queue} {field.status}...
  3. dwcats67

    Selecting specific info from mostly similar records

    Thank you, lbass, for your answer. This did, indeed, separate out the first line as requested; however, I had hoped to be able to sum up those numbers for each agent (I see now that I forgot to post that originally). Any suggestions as to how to do that now? Thank you again. dwcats67
  4. dwcats67

    Selecting specific info from mostly similar records

    I'm using CR 8.5 on SQL Database, and I've only been working with CR for a little over a month. I've searched the forums, but I can't find anything just like this situation. There's an Agent field (field.agent). I've got one field (field.status) that tells how many seconds an Agent was on a...
See more

Part and Inventory Search

Back
Top