Results 1 to 8 of 8
  1. #1
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727

    Many fields

    Gm..using Access 2016...I have a report with more than 10 fields...17 to be exact. It's already grouped as necessary. How do I organize a report with that many fields to make the report look presentable? Any suggestions would be appreciated..

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    use landscape? smaller font?

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I think it would depend on the nature of the data. Generally options include using landscape and having 2 or more lines in the detail section.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Can you make a layout on paper with a pencil that represents an acceptable report? If so, replicate that in the Access report. If not, then Access cannot either.

  5. #5
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727
    Thanks for replying...I didn't realize I could have more than one line..I do have it orientation view...how do I do this n accomplish a presentable report for VPs?

  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
    I don't think anybody who isn't familiar with the data can give you a definitive answer on how to make the report presentable. Have you asked the VPs how they'd like to see the data? I can make a report I think is a thing of beauty but the only opinions that matter are the people that will actually use it.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727
    I am taking ur suggestions and putting the data in multiple lines as not to let them run off into another page...just need to line it up so it would be presentable..yes, they just want the data on one page...I'm not that great at designing reports but I can design decent forms. Thanks

  8. #8
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    There's really nothing to add here. You just have to make your DETAIL section of your report (or your group headers/footers larger as well) wide enough to handle each 'record' where the record consists of your 17 fields. Nobody is going to be able to tell you how to arrange them in a logical order without knowing a hell of a lot more about your business and/or VP's personal preferences. Pbaldy's suggestion is the one I would follow, go ask your VP's how they want to see it, especially if the data itself is not something with which you are familiar.

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

Similar Threads

  1. Replies: 3
    Last Post: 12-02-2017, 02:04 PM
  2. Replies: 3
    Last Post: 04-24-2016, 07:24 AM
  3. Replies: 3
    Last Post: 05-03-2014, 11:00 AM
  4. Replies: 8
    Last Post: 08-02-2012, 10:50 AM
  5. Replies: 12
    Last Post: 05-07-2012, 12:41 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