Results 1 to 6 of 6
  1. #1
    Riaz is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2018
    Posts
    7

    Report required

    Click image for larger version. 
<br /><script async src=
    Name: Capture.jpg  Views: 11  Size: 48.1 KB  ID: 35730" class="thumbnail" style="float:CONFIG" />


    Hi All,

    I have a database with 3 tables, One is having all project details with Contract amount
    Second table is for entering the Variation amounts for the particular projects (Variation amount may be addition/ deletion of works for the project with amount)
    Third table is for entering the progress payments for the particular project

    i need the report as per the attached image file. Could any one HELP please

    (I could not able to attach the database file)

    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    1 way:
    is to build a query joining all tables, to get your data.
    then make a crosstab query to get your result above. (use the query wizard)

    another way:
    make a 'report' table like yours shown,
    append the data from the 3 tables to the fields,
    run a query to sum all the columns.
    run report.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Ranman, I don't see how CROSSTAB applies. Might need aggregate (GROUP BY) queries for the second and third tables then join those queries to table 1.

    Riaz, why could you not attach db? Follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    Riaz is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2018
    Posts
    7
    I have attached the db as a zip file.
    Attached Files Attached Files

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Reviewed your db and my comments are same.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    Riaz is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2018
    Posts
    7
    PROJECT DETAILS.zip

    As per your instruction, attached the zip file

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Report - Crosstabe query specific date report required
    By Kiran Prakash in forum Reports
    Replies: 1
    Last Post: 08-28-2018, 10:27 PM
  2. Support required in msaccess report
    By everwelwisher in forum Reports
    Replies: 3
    Last Post: 08-17-2015, 10:43 AM
  3. Report program required
    By proberts2014 in forum Forms
    Replies: 11
    Last Post: 07-02-2014, 02:15 PM
  4. vba code required for report
    By princeofdumph in forum Programming
    Replies: 1
    Last Post: 12-09-2011, 08:49 AM
  5. Help Required on Report List
    By cap.zadi in forum Reports
    Replies: 9
    Last Post: 09-23-2011, 05:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums