Results 1 to 3 of 3
  1. #1
    kmims44 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    May 2012
    Posts
    24

    3 Reports into 1


    I have 3 different reports each with multiple totals, I want to generate a single report as a summary report. One way I was thinking about doing this was to insert the values from those totals fields into a new table but I dont know how to link the 3 reports so that each value appears in the same new record. Is there a way to create a unique identifier for each report and insert the total values into a new table and then I can query the new table? or what is the best way to do this?
    I have 3 reports named: LaborQuoteR, InventoryAddToQuoteR, SubcontractsR. I have grand totals for each.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,530
    Have you looked at making each of those a subreport in another empty report?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    kmims44 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    May 2012
    Posts
    24
    duh good idea

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

Similar Threads

  1. Convert Client Reports to Web Reports
    By need_help12 in forum Reports
    Replies: 0
    Last Post: 05-08-2012, 08:22 AM
  2. Get all reports
    By nkuebelbeck in forum Programming
    Replies: 13
    Last Post: 06-27-2011, 12:30 PM
  3. Reports w/ sub-reports very slow to open
    By vaikz in forum Reports
    Replies: 2
    Last Post: 02-27-2011, 08:41 AM
  4. Access Reports drop sub-reports
    By Kevin Ellis in forum Reports
    Replies: 0
    Last Post: 11-19-2010, 03:28 PM
  5. Need Help on reports
    By MeehPhill in forum Reports
    Replies: 3
    Last Post: 07-31-2006, 11:51 AM

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