Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 2005 > Pro Visual Basic 2005
Pro Visual Basic 2005 For advanced Visual Basic coders working in version 2005. Beginning-level questions will be redirected to other forums, including Beginning VB 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro Visual Basic 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 30th, 2006, 08:32 AM
Registered User
Join Date: Jan 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default how do I show subtotals in an accessreport by vba

I made a module by witch I automaticly generate a report.
This report has 2 grouplevels (you can choose the field of the grouplevel in a form)
For instance :
grouplevel 1 contains the field "person"
grouplevel 2 contains the field "product the person harvest"

In the section Detail is the field Weight and weight.
There are different dates with different weights.
I would like to calculate the sum of the weights for 1 product and 1 person
and I would also like to know the sum of the different weights of all persons

I know in access you can calculate these subtotals easily in the design mode of a repport, but I would like to do this in vba because the report has to be dynamic.

Who can help me?

Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtotals bab02 Excel VBA 0 May 21st, 2007 05:56 PM
Hidden VBA module....How can I get it to show? Ben Horne Access 3 May 4th, 2007 06:43 PM
Pivot Subtotals in Bold paul20091968 Excel VBA 0 June 29th, 2006 07:03 AM
Subtotals in access report using vba bogaerts Pro Visual Basic 2005 0 January 30th, 2006 08:33 AM
Dividing Subtotals on a Report Corey Access 12 September 30th, 2005 11:39 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.