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

I think Rocky is correct.

What is supposed to show with the following:

 Acct Goal   Amt-2

 A     50.00  2.00
 A   100.00  1.00
 A   100.00  4.00
 B   200.00  5.00
 B   200.00  2.00
 B   300.00  1.00
_________________
    650.00 15.00


On Wed, Sep 29, 2010 at 1:06 PM, Brad Marks <BradM at blackforestltd.com> wrote:
> 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
>