Results 1 to 3 of 3
  1. #1
    ringram is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2014
    Posts
    16

    Post Changing footer based on the Group

    I am not sure if I just don't know how to phrase this question to find the solution on the web of if the solution is not out there.
    I have a report that is printing up a customer quote.
    There are two types of services that can be on the same quote but they need to be separated.

    example
    Group 1 detail
    description setup cost monthly reoccuring cost
    voice service A
    voice Service B
    Voice Service C
    Group 1 footer
    -----------------------------------------------------------
    Monthly total $$$$$.$$
    discount $$.$$
    After discount total $$$$.$$
    estimated taxes $$.$$
    Total Voice Costs $$$$.$$ $$$$.$$
    ----------------------------------------------------------
    (this is the second group detail)

    Internet Service A $$.$$ $$.$$
    Internet Service B $$.$$ $$.$$
    -----------------------------------------------------------
    Group 2 footer
    Internet total $$.$$
    Bundled discount $.$$
    Total internet Cost $$.$$
    ----------------------------------------------------------


    There are only 2 groups and for the most part this is a one page report

    I need to either have two different footers and suppress the footer depending on which group is printing.
    or figure out how to change the captions in the text box labels and suppress the unneeded lines the Internet section.
    any ideas?
    Today is my Friday so if you respond I will not see it till Monday.


  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Can't have two different footers for the same group level.

    Can have textboxes that conditionally display info. Instead of labels, use textboxes with conditional expressions.

    Could have subreports.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ringram is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2014
    Posts
    16
    Thanks for the advice I was toying with this idea over the weekend.

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

Similar Threads

  1. Replies: 2
    Last Post: 12-21-2013, 02:09 PM
  2. Replies: 2
    Last Post: 06-21-2012, 07:40 PM
  3. Replies: 3
    Last Post: 01-13-2011, 03:53 AM
  4. Calculation in a group footer.
    By stupesek in forum Reports
    Replies: 11
    Last Post: 09-29-2010, 07:30 AM
  5. Totaling a value in group footer...
    By hodgy20 in forum Reports
    Replies: 0
    Last Post: 11-14-2008, 08:28 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