Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1860
  • Last Modified:

MS Access report viewing totals

This seems like it should be simple, but I have tried different things and can't get it to work.  I have a group of items and I want to only show the final total at the end of each group.  Each group could be one page or two pages.

For example,

Group 1
      item      price
      item       price
      item      price

Total of group      Sum of Price

Group 2
.....

Can you help me get the total to print only once?  I have it where it prints after every item, but I would like to only see it at the end of each group.

Thank you.
0
kylelinkuhn
Asked:
kylelinkuhn
  • 3
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Make sure that your 'final total' control is in the Group Footer for Item, and not in the Group Detail.

Also, if you do not wish to display the items, hide the Group Detail by setting its Visible property to No.
0
 
kylelinkuhnAuthor Commented:
I have it in a Group Footer for the value I want to total up, which in my example is price.  So do I want to create a Group Footer for the value that Group 1 is defined by or by "item" in the above example?

Thank you for your help.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Groups in Access Reports (at least up to 2003) are nested, and not sequential.

Group 0 Header
Group 1 Header
Detail for all:   item      price
Group 1 Footer: Total of group      Sum of Price
Group 0 Footer
0
 
kylelinkuhnAuthor Commented:
Okay, I have it set up this way, but it still shows up after each record.  Is it because I have code written like this:
Private Sub GroupFooter0_Format....
    Me.Total = gintTot
End Sub

I tried to make it Me.Total.Visible=True/False, but it is not a property for Me.Total, which is a textbox.
0
 
kylelinkuhnAuthor Commented:
I used  Me.TotalNetBilled.Report.Visible = True to try to make it visible, but I got an error "You entered an expression that has an invalid reference to the property Form/Report."  Any thoughts?

Thank you for the help.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now