Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    counting records and sum on a report (2003)

    Hi,

    I would like to put four text boxes in the footer of report.

    1) Total of cases if Sign is null - Try to use "=IIf(IsNull([Coders]),Count([Sign))". It doesn't work, it shows the number of all record in the report include Sign field is null or is not null.
    2) Total of cases if Sign is not null
    3) The sum of balance field if Sign is Null - Don't know what to put in Control Source
    4) The sum of balance field if Sign is Not Null

    Thanks in advance.

    Regards

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

    Re: counting records and sum on a report (2003)

    1) =Abs(Sum(IsNull([Sign]))) what does Coders have to do with this?

    2) = Abs(Sum(Not IsNull([Sign])))

    3) =Sum(IIf(IsNull([Sign]),[Balance]))

    4) =Sum(IIf(Not IsNull([Sign]),[Balance]))

  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: counting records and sum on a report (2003)

    Thank you so much, hans.

Posting Permissions

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