Results 1 to 6 of 6
  1. #1
    flash is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Oct 2016
    Posts
    3

    Displaying data as columns

    Hi All,


    I have 3 query results like the below
    I want to combine the 3 results into one result (Final Result) using a query.
    Please assist
    Result A

    Region TotalMembership
    A 40
    B 50
    C 70

    Result B

    Region TotalMembersPaid

    A 33
    B 44
    C 61


    Result C

    Region TotalMembersNotPaid
    A 7
    B 6
    C 8
    Final Result

    Region TotalMembership TotalMembersPaid TotalMembersNotPaid

    A 40 33 7

    B 50 44 6

    C 70 61 8

  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,518
    A query that joins all 3 on the region field should work. I'd expect a regions table, which I would use as the base and left join the 3 queries to it.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    flash is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Oct 2016
    Posts
    3
    Hi,
    Thanks for the reply
    Results A,B,AND C are all SQL views
    The regions is also not from a table

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You should still be able to join them in a query, presuming they are linked to Access. Or do it all as another view in SQL Server. The point is, the way to get your desired result is via joining those.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    flash is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Oct 2016
    Posts
    3
    Hi,
    Thanks for the reply,
    My issue is not really about the joining, its how to join the 3 queries so i get the values in column rather than rows

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    It's not about joining, it's how to join? Add the 3 queries to a new query, and the regions table/view if you have one. Join each query to the regions table on the region field. Select the region field from the region table and each of the 3 value fields from the 3 queries. If you're still confused, attach a sample db with tables that are the same as your data above.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 3
    Last Post: 02-17-2015, 02:27 PM
  2. Replies: 1
    Last Post: 07-07-2013, 12:47 PM
  3. Displaying Data in a Report
    By im_eric in forum Reports
    Replies: 3
    Last Post: 01-20-2012, 04:43 PM
  4. Displaying Hierarchical data
    By Gerry in forum Programming
    Replies: 10
    Last Post: 04-17-2010, 06:50 PM
  5. Displaying data in Access from SQL
    By BeckyAccess in forum Queries
    Replies: 0
    Last Post: 06-30-2009, 01:57 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