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:33 AM
Registered User
 
Join Date: Jan 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Subtotals in access report using 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.

In the attachment you can find the code for making the report (it's in dutch)







Similar Threads
Thread Thread Starter Forum Replies Last Post
Access VBA Report Criteria anterior Access VBA 17 October 24th, 2007 07:13 AM
Generating report via VBA in Access gurkie Access 2 July 16th, 2006 02:16 PM
how do I show subtotals in an accessreport by vba bogaerts Pro Visual Basic 2005 0 January 30th, 2006 08:32 AM
Dividing Subtotals on a Report Corey Access 12 September 30th, 2005 11:39 AM
Need help creating word report from Access VBA emapis Access VBA 2 November 10th, 2004 05:24 PM





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