[AccessD] Final Totals on Access Report to not include all report 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.