Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Grand Total of Elapsed Times (2003, sp2)

    I have a report that includes a transaction start and end time. I added a calculated field to the detail section that calculates the elapsed time ([stop time] - [start time] for each transaction. I want my report footer to calculate the grand total of the elapsed time. The name of the field is [Text28]. If I do a sum in the report footer and switch to Print Preview it shows [Text28] as a parameter prompt. I have attached a copy. Any easy way to fix this? TIA
    Attached Files Attached Files
    egghead

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Grand Total of Elapsed Times (2003, sp2)

    You can only aggregate (i.e. sum, average etc.) expressions that refer to fields in the record source, not controls such as text boxes. You can do the following:
    - Duplicate the Text28 text box in the group header control.
    - Name the duplicate (for example) txtRunSum.
    - Set the Running Sum property of the duplicate to Over All (or Over Groups, that doesn't matter here).
    - Set the Visible property of the duplicate to No (users don't need to see it, it is only used to compute the total).
    - Set the Control Source of the text box Text37 in the report footer to =[txtRunSum]

  3. #3
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grand Total of Elapsed Times (2003, sp2)

    Great idea. Works great and is very easy! Thanks.
    egghead

Posting Permissions

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