Results 1 to 1 of 1

Thread: [RESOLVED] MS Access multiple grouping proper presentation

  1. #1

    Thread Starter
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478

    Resolved [RESOLVED] MS Access multiple grouping proper presentation

    No help needed anymore, have created a report through code who writes to Excell, and it looks like I wanted it.

    Anyone who can help me with grouping on report with proper presentation ?

    I got
    Code:
    Group 1 = First
    Group 2 = Second
    Data
    
    First 1
        Second 1
            Data 1
            Data 2
            Data 3
        Second 2
            Data 1
            Data 2
            Data 3
        Second 3
            Data 1
            Data 2
            Data 3
            
    First 2
        Second 3
            Data 2
            Data 4
            Data 5
        Second 4
            Data 2
            Data 4
            Data 5
    I want it to be shown as
    Code:
    Group 1 = First
    Group 2 = Second
    Data
    
    First 1
        Second 1
        Second 2
        Second 3
            Data 1
            Data 2
            Data 3
            
    First 2
        Second 3
        Second 4
            Data 2
            Data 4
            Data 5
    Can't find anything to make this work.
    In db i got 2 tables
    1st table got 2 fields
    First Second

    2nd table got 2 fields
    First Data

    Those are connected through First.
    In 1st table there are no doubles, Key is combination of the two fields.

    Hope u can understand it.
    Last edited by swatty; Dec 7th, 2009 at 10:18 AM.
    Code:
    If Question = Incomplete Then
       AnswerNextOne
    Else
       ReplyIfKnown
    End If
    cu Swatty

Posting Permissions

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



Click Here to Expand Forum to Full Width