Results 1 to 4 of 4
  1. #1
    allenjasonbrown@gmail.com is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    44

    Footer Totals

    Hi -


    I am trying to generate footer totals and having issues. In the header I have an iif statement which generates 2 lines for an individual:

    Header:
    iif(Answer like 'y',Yes,No)

    D Smith
    'Yes' 1 1 1
    'No' 2 3 4
    B Smith
    'Yes' 1 1 1
    'No' 2 3 4

    Footer Totals
    Totals 7 8 10


    I need to be able to total the Yes and No separately..........can this be done?

    Thanks.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Try something along the lines of:

    =Sum(IIf(Answer = 'y', FieldName, 0))
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    allenjasonbrown@gmail.com is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    44
    Thanks but that did not seem to work.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    What does "did not seem to work" mean? Did you change the field name to match yours? It would work in a group or report footer, not a page footer.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Page Footer
    By jamil_kwi in forum Access
    Replies: 1
    Last Post: 05-31-2010, 04:02 AM
  2. sum in form footer
    By dean in forum Access
    Replies: 1
    Last Post: 09-11-2009, 02:35 AM
  3. Problems with SUM in Report Footer
    By bonetakc in forum Forms
    Replies: 1
    Last Post: 07-30-2009, 04:53 AM
  4. Need help with values in the footer
    By allochthonous in forum Reports
    Replies: 0
    Last Post: 03-03-2007, 08:20 PM
  5. Page Footer Top
    By RHall in forum Reports
    Replies: 3
    Last Post: 12-15-2005, 09:35 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums