Results 1 to 11 of 11
  1. #1
    kroenc17 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2010
    Location
    Albany, NY
    Posts
    49

    extra detail sections


    I'm making a report that needs to have more than one detail section.. one for each group I create.

    Each group shows a different activity: Projects, Misc., Special Assignments.

    The header for each group shows different captions (in bold on the attached picture) which differ depending on which activity it is.. for example, Projects have an End Date, Misc. do not. Each Header section needs it's own Details section and this will work perfectly.

    The details section shows the actual data. I don't know how to create separate details sections, my Access 2007 for Dummies book is saying they should be created automatically.. maybe I'm doing something wrong?

    Thanks for the help.

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    How many detail session do you want?

  3. #3
    kroenc17 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2010
    Location
    Albany, NY
    Posts
    49
    I need three detail sections

  4. #4
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    can you put the captions in group header instead of report header?
    you can have as many group header as you need.

  5. #5
    kroenc17 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2010
    Location
    Albany, NY
    Posts
    49
    Besides my report header and page header, there need to be three groups with three headers and three detail sections. I can make the extra groups and their headers, but I don't know how to create the detail sections.

    The captions are different for each section, so they are in each group header. The report header is just the report title.

  6. #6
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    I think you mixed up group and detail.

    There is only one detail session in a report. if you want them in different session, it is called groups.

    In the other way, assume you can create 3 detail sessions, how do you seperate the data in different session? you need some criteria to identify the data, right? So what is the different with 3 groups?

    I still suggest you to create groups.

  7. #7
    kroenc17 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2010
    Location
    Albany, NY
    Posts
    49
    I'm using Access 2007 so maybe it's labeled differently on your version. Look at the image I attached in the first post.. I have separate groups created. Each Group Header has the activity type in blue, and the captions are in bold. The Group Headers identify the type of activity, in the image it shows Projects and Misc. and show the captions. The captions differ for each group, because the data shown is different for each group. The data itself is in the Details section, where it displays correctly, does not repeat entries, looks exactly how I want it.

    I just need to have a Details section for every group.

  8. #8
    kroenc17 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2010
    Location
    Albany, NY
    Posts
    49
    I've attached the report and design view of the report I need to make. What I need is exactly what's there, except I need to have three different headings (the headings show the Activity Type in blue, and my captions in bold). Projects, Misc. Special Assignments are the headings. They're all going to have slightly different captions, and which data is shown.

  9. #9
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    you can put 3 groups in detail session instead of putting each session in 3 groups. just need to determine the group titles (captions)

  10. #10
    kroenc17 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2010
    Location
    Albany, NY
    Posts
    49
    My group & sort section gives me no option to put the groups into the Detail field. How do I do that?

  11. #11
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    when you create group, they are in detail session., may be you need to check "show group header"

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

Similar Threads

  1. 2010 Reports print an extra page
    By dhbazan in forum Reports
    Replies: 7
    Last Post: 11-15-2012, 06:43 PM
  2. Remove extra page from report?
    By sunny in forum Reports
    Replies: 2
    Last Post: 10-17-2012, 11:30 AM
  3. Extra space added
    By allenf in forum Forms
    Replies: 2
    Last Post: 07-25-2010, 06:57 AM
  4. Multiple Details Sections of report
    By nkuebelbeck in forum Reports
    Replies: 1
    Last Post: 03-17-2010, 09:34 AM
  5. Extra date field update
    By georgft in forum Forms
    Replies: 0
    Last Post: 09-17-2008, 06:51 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