Results 1 to 2 of 2

Detail in columns

  1. #1
    marcusp is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    1

    Detail in columns

    I have been searching the boards and cannot see a simple solution for a simpleton on this. I am trying to create a report where my detail are in columns under the group header. Specifically I have a number of boxes 1-30 that have 150 serialized items in each. I can get the columns but not seperate from the box

    my report looks like this:

    1 (box no) 1235 2344
    4555 4574 150 (count)
    1235 1234 2 (box number)
    1254 1657 2144
    1254 2134 6584

    What I want is

    Box Number: 1 Count in Box: 150

    1235 2548
    2458 2584
    6544 1474
    6584 1448

    Box Number: 2 Count in Box: 150

    2548 4587
    2584 4568
    2548 3857

    I hope this is clear and someone can help. Apologize if this is really basic I just cant figure it out

  2. #2
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    28,052
    Don't understand.

    Does the report output shown reflect how data is stored in table? Box number is not always in same column? Not every row has a box number?

    Numbers in 'What I want' are not same as in the report output sample. Can't reconcile the two examples.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

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

Similar Threads

  1. Columns in Report Detail Section only
    By gg80 in forum Reports
    Replies: 10
    Last Post: 08-03-2014, 06:41 PM
  2. More detail required
    By coach32 in forum Queries
    Replies: 3
    Last Post: 12-05-2011, 03:42 AM
  3. Replies: 1
    Last Post: 12-04-2011, 12:16 AM
  4. Detail form
    By karuppasamy in forum Access
    Replies: 5
    Last Post: 05-26-2011, 06:39 AM
  5. columns for group detail but not group header?
    By Coolpapabell in forum Reports
    Replies: 0
    Last Post: 08-21-2009, 07:53 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
  •  
Tech Forums: Microsoft Office Forums