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!

  • Congratulations SkipVought 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. rhartigan

    Need to sum hours from calculated elapsed time field that is a string

    Wow, thanks everyone. So, I apologize if this was confusing. What sounds perfectly simple in my head is of course difficult to translate into understandable English. All I really needed was accomplished in Step 1 of what Pete posted up above. I just needed the values in order to convert to a...
  2. rhartigan

    Need to sum hours from calculated elapsed time field that is a string

    Thanks for the help. I looked at TimeSerial but I am trying to do a summary for a group and beyond the 24 hour issue it doesn't seem to be the way I need to go. Literally, the record is ComputedTime=02:30 and I'm trying to sum the computed time for the group. So, I went back to my 6th grade...
  3. rhartigan

    Need to sum hours from calculated elapsed time field that is a string

    I have a string field that is Computed Time showing for example, 02:30. I have tried converting a number of different ways and even using the primary fields of Date Left and Date Returned to calculate the number of hours between but I can't seem to get the summation correct when adding 02:30 and...
  4. rhartigan

    best way to group or show report

    Anywhere, including the Report Footer is fine, I just need to see the totals. Sorry for not mentioning it sooner. Some of this I had hoped to figure out for myself. Thanks!
  5. rhartigan

    best way to group or show report

    Thank you so much!!! Grouping is definitely one of my weakest areas of crystal. Just one more question if you don't mind, how would I count the number of inmates under each charge type grouping. I've tried running totals but can't seem to get it. Thanks again! rhartigan
  6. rhartigan

    best way to group or show report

    I'm working on a report to show or group inmates. Each inmate has charges which are either misdemeanor or felonies. Most inmates have both and a few are either one or the other. Right now it looks kind of like this. inmate 0001a (Grouped by Inmate Number) Charge 1 Misdemeanor...

Part and Inventory Search

Back
Top