[AccessD] Final Totals on Access Report to not include allreport rows

Make the report as usual and fill in the totals in the format event of the
report footer using the query?

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Wednesday, September 29, 2010 2:03 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Final Totals on Access Report to not include
allreport rows

I should have mentioned earlier that we need to keep the detail lines on the
report for Amt-2.

Sorry

In other words, we want to show the lines as shown in the example below.

The trick is that we want to have a total for Goal that only includes one
occurrence of the Goal Amt for each Acct.

Brad
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Wednesday, September 29, 2010 3:47 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Final Totals on Access Report to not include
allreportrows

WAG - 

Extract the Acct Goal values in a query using Unique Values property of the
query = True?  If that works then make it a summation query on the Acct Goal
field and it should say 300.

Rocky

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Wednesday, September 29, 2010 1:06 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Final Totals on Access Report to not include all
reportrows

All,

I ran into a unusual situation recently.
I have developed a solution with some VBA code, but afterwards I wondered if
there is a better approach.

Below is a small sample of the data that needs to be on a report.

The Goal for Acct "A" is 100.00, the Goal for Acct "B" is 200.00.

During a month, transactions are done with amounts stored in "Amt-2".

We now want to have final totals.  The catch is that we only want to add an
Account's Goal one time to the final total for each account (Final total of
300.00 instead of 600.00)

Is there a simple way to obtain these results in an Access Report?

The VBA method works, but there probably is a better way to do this.



Acct Goal   Amt-2

A   100.00  1.00
A   100.00  4.00
B   200.00  5.00
B   200.00  2.00
_________________
    300.00 12.00 



Thanks,
Brad

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com