Results 1 to 2 of 2
  1. #1
    tigers is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2006
    Posts
    28

    Can a do this? A really horizontally long report (A few rows of labels to many columns of data)

    Hi,

    I think I am trying to do excel in Access. Basically, the report I am trying to create has a group and then several names below that with many columns of data amounting to about 4 pages per group (in excel). I am trying to automate this in Access doing the same exact thing but the dot grid (report/design/property sheet/Format/grid x) will only allow me to expand to 64 and I need more room. Is there a different way I could approach this so that I could keep the four pages together by Group?

    Here is how I want it to look design wise with the asterisks being the page breaks:




    Group A
    Name Data 1 Data 2 Data 3 Data 4 Data 5 * Name Data 6 Data 7 Data 8 Data 9 Data 10 * Name Data 11 Data 12 Data 13 Data 15 * Name Data 16 Data 17 Data 18 Data 19 Data 20
    Person 1 * Person 1 * Person 1 * Person 1
    Person 2 * Person 2 * Person 2 * Person 2
    Person 3 * Person 3 * Person 3 * Person 3
    Total * Total * Total * Total


    THANK YOU!!!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    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. Transpose Data from Rows to Columns
    By Crdmster in forum Queries
    Replies: 1
    Last Post: 08-08-2017, 02:18 PM
  2. Help Displaying Data Horizontally In Report
    By bgwool in forum Reports
    Replies: 10
    Last Post: 09-04-2014, 03:32 PM
  3. Deleting rows deletes all columns in my report
    By Access_Novice in forum Reports
    Replies: 3
    Last Post: 09-19-2013, 06:15 PM
  4. Replies: 4
    Last Post: 04-09-2012, 01:54 PM
  5. Replies: 0
    Last Post: 03-11-2010, 09:06 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