Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Location
    wakefield, ri
    Posts
    35

    Unanswered: Calculating in a report

    In a report I have groups named "Project" which has multiple values and "Request" which has only two values. In the "Request" group footer I have done totals of numbers from three fields (=NZ([VerifyTime])+NZ([CMEffort])+NZ([CatalogTime]). The problem I have is getting a grand total for the two values.

    Any suggestions will be well received. Thanks.

  2. #2
    Join Date
    Nov 2004
    Posts
    22
    Quote Originally Posted by gatewoodps
    In a report I have groups named "Project" which has multiple values and "Request" which has only two values. In the "Request" group footer I have done totals of numbers from three fields (=NZ([VerifyTime])+NZ([CMEffort])+NZ([CatalogTime]). The problem I have is getting a grand total for the two values.

    Any suggestions will be well received. Thanks.
    Have you tried a conditional sum of some sort? If we assume that Request has one of two values, 0 or 1, then I would do the following:

    For Request = 1:
    Create unbound text boxes in the report footer and put the following expressions in as the control source:

    iif([Request]=1,sum([VerifyTime]),0)
    iif([Request]=1,sum([CMEffort]),0)
    iif([Request]=1,sum([CatalogTime]),0)

    For Request = 0:
    Create unbound text boxes in the report footer and put the following expressions in as the control source:

    =iif([Request]=0,sum([VerifyTime]),0)
    =iif([Request]=0,sum([CMEffort]),0)
    =iif([Request]=0,sum([CatalogTime]),0)


    I hope that I understood your problem correctly. If not, perhaps you could post a copy of the forms/tables/queries that you are working on.

    Cheers,

    Craig
    rockjock

Posting Permissions

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