Multiple detail section on an access report

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Multiple detail section on an access report

  1. #1
    New Member
    Join Date
    Oct 2004
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Multiple detail section on an access report

     
    Is is possible to have multiple detail sections in an access report. If so how can I do this.

    Thanks,

    Alan

  2. #2
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    42,711
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    2 Thread(s)

    Default

    Without knowing the exact structure of your data and knowing exactly what you are trying to do, it is hard to give a definitive answer. But, in most cases, one of these two options should work:

    1. Group your data and set up separate Group Headers which will give you the effect of multiple Detail sections (for each Group)

    2. Investigate setting up and using Subreports (See Access help for details)
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    New Member
    Join Date
    Jan 2011
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multiple detail section on an access report

    Thank you I just googled a solution to this and found your thread! The grouping worked perfectly!

  4. #4
    MrExcel MVP boblarson's Avatar
    Join Date
    Nov 2008
    Location
    Portland, Oregon, USA
    Posts
    1,964
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multiple detail section on an access report

      
    I WISH Access could have multiple detail sections (as well as multiple of the same group headers, etc) like Crystal Reports can. But while it can do reporting it is not a dedicated reporting tool like Crystal Reports. So it has many features for doing reports but it doesn't give you a lot of ones that would make it even easier. If I could do Crystal Reports for all of my reports instead of Access reports, I would love it.
    Bob Larson
    Former Access MVP (2008-2010, 2011)

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com