Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Posts
    2

    Unanswered: How to perform calculation in Access REPORT (2007)

    Hi,
    How can I do calculation in Access Report.I have 4 Reports,Named APPLICATION,STATIONERY,COMPUTER and the main report as BOOKING INVOICE

    Subrepot 1(APPLICATION) has below field/cell
    Date Quantity Category Price TOTAL
    12/03/009 2 Printer $200 $400.00
    12/03/009 1 Cam/coder $150 $150.00
    TOTAL FOR SUBREPORT 1 = $550.00
    SUBREPORT 2 (STATIONERY)
    Date Quantity Category Price TOTAL
    12/03/009 2 Books $20.00 $40.00
    12/03/009 1 Pen $5.00 5.00
    TOTAL FOR SUBREPORT 2 = $45.00
    SUBREPORT 3 (COMPUTER)
    Date Quantity Category Price TOTAL
    12/03/009 3 Desktop $250.00 $750.00
    TOTAL FOR SUBREPORT 3 = $750.00


    Those are my Reports and the fouth Report is Booking Invoice.I had add these three report as subreport to main Report (BOOKING INVOICE).What l want to do is l want to add these three (Total for Subreport 1,2 and 3) like
    TOTAL FOR SUBREPORT 1 =550.00
    TOTAL FOR SUBREPORT 2 =$45.00
    TOTAL FOR SUBREPORT 3 =$750.00 And get below result
    (AND TOTAL DUE)? = $1345.00

    What I want to do on Booking Invoice Report is how to calculate all Subreport Total to get TOTAL DUE? Any help will be appreciated.

    FEMI.

  2. #2
    Join Date
    May 2009
    Location
    Ottawa, Canada
    Posts
    11
    Make a text box and make the control soruce something like:

    =[Subreport1Total]+[Subreport2Total]+[Subreport2Total]

    What ever the name of your fields are. Pretty much like what your would do in a query, only this time just put it in a text box control source and it should calculate it for you.

    Hope that helps

  3. #3
    Join Date
    Aug 2009
    Posts
    1
    rashoku

    that would be fine if all the controls were on the same report, but they are not. femdey01 is looking to calculate the total of the three total fields, each from a subreport all located on the main report. I would think that you need to mention how to reference a field/control on a subreport. At any rate, I too am interested in the answer.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Referencing an object on a subform:

    =MySubformObjectName!TheObjectIWantToReferenceOnTh eSubform
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •