Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    An easy Time question

    I have a field which totals time (format is short time).
    There is a "SUM=([Time])" in the group footer. (this works)
    Then I have a section footer and a report footer.
    Those two times do not sum correctly. Short time just rolls over rather than keep a total-when I convert to number formats I lose the time.

    I feel as if I've tried every type of formatting and options in the properties boxes.
    I've tried =Sum(Grand Total Time) after renaming the group textboxes.
    What am I missing?
    <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: An easy Time question

    When you say "rolls over", do you mean that it adds the total from the previous section to the total from each following section?

    Is the Running Sum property set to "Over All" or "Over Group"? You may want to play with that property...

    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •