[AccessD] Final Totals on Access Report to not includeallreportrows

A.D.,

Thank you very much for the assistance.

Your ideas greatly helped to solve the problem that I was working on.

I appreciate your help.

Sincerely,
Brad

  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal
Sent: Sunday, October 03, 2010 12:25 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Final Totals on Access Report to not
includeallreportrows

Brad,
    
    You wish to show the values for Acct, Goal and Amt on each row in
detail section of report but at the same time, while showing overall
totals in report footer, ignore duplicate occurrences of Goal values in
each account.

    For a codeless solution as sought by you, following course of action
is suggested:

    1 - In Sorting and Grouping dialog box, create a group footer for
Acct
    2 - In this group footer, place a calculated text box named TxtGoal
with the expression =[Goal]. On data tab of property sheet for this text
box, set its running sum property to OverAll.
    3 - Hide the group footer section by setting its visible property to
No.
    4 - In the report footer, place a calculated text box named
TxtTotGoal with the expression =[TxtGoal], and another calculated text
box named TxtTotAmt with the expression = Sum[Amt].

    With the above arrangement, overall totals will get displayed in
report footer in the manner desired by you (ignoring duplicate
occurrences of Goal values in each account).

Best wishes,
A.D. Tejpal
------------

  ----- Original Message ----- 
  From: Brad Marks 
  To: Access Developers discussion and problem solving 
  Sent: Thursday, September 30, 2010 23:45
  Subject: Re: [AccessD] Final Totals on Access Report to not
includeallreport rows


  Gary,

  Good idea, I hadn't thought of that approach.

  I wrote some VBA code to handle this unusual situation, but I would
prefer another approach.

  Thanks,
  Brad   

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
  Sent: Thursday, September 30, 2010 6:39 AM
  To: Access Developers discussion and problem solving
  Subject: Re: [AccessD] Final Totals on Access Report to not include
allreport rows

  How about if you used only the account number totals in the main
  report and then listed the individual transactions for each account in
  a sub report? Then those goals on the individual transactions wouldn't
  mess you up on the final totals as that would be only the data from
  the main report.

  Just a thought before I have had any coffee.

  GK

  On Wed, Sep 29, 2010 at 3: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

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