Results 1 to 2 of 2
  1. #1
    bamerand is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2014
    Posts
    2

    Two-column report with group by number

    My question seems to be very easy, yet I am struggling in finding an answer. I have a table with the following information: First Name, Last Name and Group Number



    #
    First Name Last Name Group Number
    1 Alex Bloom Group No.1
    2 Peter Pan Group No.2
    3 Jaime Flower Group No.2
    4 Cat Boone Group No.1


    I need to prepare a report in MS Access so that the data is grouped by number in two columns. For instance, it should like in the table as follows:


    #.
    First Name Last Name Group Number #
    First Name Last Name Group Number
    1 Alex Bloom Group No.1 1 Peter Pan Group No.2
    2 Cat Boone Group No.1 2 Jaime Flower Group No.2

    Anyone can give me an answer, pls?


    Regards,




    Dan.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In the property of the report
    lookin in PAGE SETUP tab
    COLUMNS
    set to 2.

    But for your format shown, you may have to do something differntly to get ALL of col 2 to be 'level' with col 1.
    Like write to a 'report' table in order for the 2 columns to show side by side.
    Like a query to pull Grp1 in col 1, and Grp2 in col 2.

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

Similar Threads

  1. Report Group - Show empty Group
    By crimedog in forum Reports
    Replies: 2
    Last Post: 12-30-2013, 01:06 AM
  2. Replies: 2
    Last Post: 03-28-2013, 05:59 PM
  3. Replies: 2
    Last Post: 12-05-2011, 04:53 AM
  4. Limit number of records in report by group
    By Dr Ennui in forum Reports
    Replies: 0
    Last Post: 06-22-2010, 12:36 AM
  5. Replies: 1
    Last Post: 03-19-2010, 05:17 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