Results 1 to 4 of 4
  1. #1
    dso808 is offline Novice
    Windows XP Access 2003
    Join Date
    May 2010
    Posts
    6

    Access Report using UNION queries - Can I seperate the query results in the report?

    I have a report that uses a set of 4 queries joined by unions. The 4 queries are simply selects for 4 different groups - for example, group A, group B, group C, and group D. The report works fine but now the user has a new request.



    Obviously, the returned result from the query just displays as one long report. Is it possible to seperate the results from groups A, B, C, and D in the report? For example, when group A finishes, create a page break and go to a new page to start group B.

    Can this be done without simply creating seperate reports for the different groups? Thanks in advance!

  2. #2
    TG_W is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2010
    Location
    Manvel, TX
    Posts
    299
    Have you tried to "Group" on your groups?

  3. #3
    dso808 is offline Novice
    Windows XP Access 2003
    Join Date
    May 2010
    Posts
    6
    Thanks TG_W. OK, I created a Group Header for my groups in 'Sorting and Grouping' and then in the 'Keep Together' property, I set it to 'Whole Group' and that seems to do the trick. Thanks again!

  4. #4
    TG_W is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2010
    Location
    Manvel, TX
    Posts
    299
    Not a problem. I'm glad I could be of assitance.

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

Similar Threads

  1. Complex Query/Queries for a Report
    By Rawb in forum Queries
    Replies: 3
    Last Post: 02-04-2010, 07:44 AM
  2. Making report from 2 queries
    By QueeN in forum Reports
    Replies: 1
    Last Post: 04-20-2009, 01:36 PM
  3. Search Form Results Displayed In Report
    By warrenjburns in forum Forms
    Replies: 1
    Last Post: 03-18-2009, 02:08 AM
  4. Replies: 1
    Last Post: 02-02-2009, 05:52 AM
  5. Replies: 0
    Last Post: 12-28-2008, 01:56 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