Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Posts
    280

    Unanswered: How do you eliminate data on a footer of a report?

    I just want to show the data on the header but I don't want some of the data to be total up in the footer.

    Example...

    Therpistname header
    FacilityID header
    FacilityID Footer
    Therapistname Footer

    1.) Show facilityid 1,2,3 for the header
    2.) Eliminate facilityid 3 for the footer but total up the amount with the facilityID not equal to 3.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Set the detail section to invisible in the OnPrint event if the facility id is three. Set the sum fields to an iif() statement:

    =sum(iif(facilityID = 3, "0", whateveryou'resumming))
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Apr 2003
    Posts
    280
    Quote Originally Posted by Teddy
    Set the detail section to invisible in the OnPrint event if the facility id is three. Set the sum fields to an iif() statement:

    =sum(iif(facilityID = 3, "0", whateveryou'resumming))
    I actually tried that but in a different way, which is wrong.
    This is what I did before:
    iif(facilityID = 3, "0", Sum(whateveryou'resumming))

    Anyways, how do you add another facilityid to the condition?

  4. #4
    Join Date
    Apr 2003
    Posts
    280
    Nevermind! Thanks Teddy!

Posting Permissions

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