Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Dec 2004
    Location
    Fort Collins, Colorado, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Report (2K or XP)

    I want to create a report that posts table row elements horizontally on the page (five columns) up to a sub-total column, then print vertically the next row elements that DO NOT match the 5 previous columns until the group variable changes. In plain words; print a group header of 5 columns, print down the successive group rows, then start over on the break variable with a new header. Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access Report (2K or XP)

    I don't think I understand what you're looking for. I assume that by "table row elements", you mean fields, correct? So what do you mean by this?
    <hr>then print vertically the next row elements that DO NOT match the 5 previous columns until the group variable changes<hr>
    I would guess that by "print vertically", you mean print rows down the page, and the group variable you mention is probably a header grouping, right? Are you using sorting and grouping in the report or have you grouped the data in an underlying query?
    Charlotte

  3. #3
    Lounger
    Join Date
    Dec 2004
    Location
    Fort Collins, Colorado, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Report (2K or XP)

    I've attached a rough example...

    Table Column Type Amount CustNo (not shown)
    wav 25
    wav 10
    der 20
    deg 21
    xyz 345
    aaa 106

    now make report
    wav der deg Sub-total Other Amount
    35 20 21 76 xzy 345
    aaa 106
    break variable grouping on CustNo

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access Report (2K or XP)

    This type of report is very alien to Access. Offhand, I can't think of an easy or elegant way to produce it. You will probably have to do much of the formatting of the report in code. Are you really sure you need this?

  5. #5
    Lounger
    Join Date
    Dec 2004
    Location
    Fort Collins, Colorado, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Report (2K or XP)

    Yeah, that's what I figured. I told the client it would take at least two tables (to split off the horizontal members) and lots of code. But I had to confirm, since I can't know everthing that Access will do... thanks folks

Posting Permissions

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