Results 1 to 2 of 2
  1. #1
    Derrick T. Davidson is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2013
    Posts
    142

    Multi quieries one report

    Is it possible to create a report from several queries? i.e. I have a gross revenue, a net revenue, a gross cost and a net cost spanning 52 weeks can I intergrate to show a basic P&L?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    I expect it can be done. Might be by joining the queries or use of subreports.
    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.

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

Similar Threads

  1. Replies: 6
    Last Post: 05-15-2013, 03:36 PM
  2. Dynamic Headings on Multi Column Report
    By EddieN1 in forum Reports
    Replies: 7
    Last Post: 08-19-2012, 02:39 PM
  3. Replies: 5
    Last Post: 06-01-2012, 03:59 PM
  4. Multi table query & report
    By memphis212 in forum Queries
    Replies: 3
    Last Post: 07-12-2011, 10:59 PM
  5. Help combining two quieries to output
    By AccessUser1234 in forum Access
    Replies: 3
    Last Post: 04-01-2010, 01:59 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