Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2011
    Posts
    66

    Unanswered: how get the total sum of two queries in one report ( Pls Support )

    i have two queries in which i get the total numbers of [test date1] total

    query1 = tiscodata
    query2 = jindaldata

    iam able to get the sum of both queries seperately total smaples tested based on [test date1] in the report named

    report1 = tiscoreport
    report2 = jindalreport

    if i select from (( form [dataa] )) the stARTdate and enddate and click [[open tisco report ]] it will give total of tisco between those dates if i select same the stARTdate and enddate and click [[open jindal report ]] i get the jindal report

    my question is how to take the total samples tested from startdate to enddate from both query1 = tiscodata and query2 = jindaldata in the same report as i click [[[ open both in one report ]]] have to get many queries total in one report

    can any one pls help through a vba code or by joining the queries to come in one report
    attached database for reference pls help
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    183
    Your database with the new Report (JindalTisco) is attached.
    Attached Files Attached Files
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

  3. #3
    Join Date
    Sep 2011
    Posts
    66

    apr pillai thanks for the support

    pillai thanks for all the support i got it but what i require is the tisco total and jindal total should be seperate it should not be totaled together

    pls see any thing can be done for this

    attached photo for reference
    Attached Thumbnails Attached Thumbnails report.JPG  

  4. #4
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    183
    Database with modified Reports is attached.
    Attached Files Attached Files
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

  5. #5
    Join Date
    Sep 2011
    Posts
    66

    thanks for all the support

    pillai thanks for all the help its working fine. if i export this report to excel iam not getting the data it cannot be exported to excel is it

    and thanks for all the support done as i have to include many reports......

Posting Permissions

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