Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2008
    Posts
    4

    Lightbulb Unanswered: 1 Solution for transposing in Access (I need to develop another)

    I have come up with a solution for developing a report to display data vertically, instead of horizontally in Access 2000...
    to make the report, just make a normal tabular report, REVERSING order of the columns. select the text boxes and lables and set the vertical option to yes. adjust your textbox and lable size.

    This works... to a point.. it is memory intensive(see NOTE1) on larger reports.
    _____________________
    About my Database:
    I pull 10k+ records per day from a larger database, utilize queries to agregate it to:
    25 columns
    29 rows per (day, week, month depending on report)
    right now I have my end query dumping it to a table and then dropping it out to excel, using the cut and paste transpose method and reporting from there, because my work computer(see NOTE2) crashes if I do the previous method.

    (NOTE1: It is the vertical option that kills the report)
    (NOTE2: my personal computer will still do it, but I work in a government facility.... can't upgrade work computer.... can't use personal)

    can ya'll help me develop a way to:
    automate droping it out to excel (including a autorun macro / code / script to transpose it) and import it back to access from WITHIN access

    or
    another trick like above that will work on my work computer

    or
    independent solution

    CRITERIA
    can not upgrade computer
    can not upgrade access (currently 2000)

  2. #2
    Join Date
    Feb 2008
    Posts
    4

    Converting a table from M*N to N*M

    I have spent 16+ hours researching this problem on the internet...... (better than half on my own time). The purpose of this database is a Lean Six Sigma project for a older L6S Black Belt, who is not the most technically savy. Since posting the original message I have found the following code, but have no clue where it would be implemented.


    # with this infile:
    #
    # a b c d
    # e f g h
    # i j k l
    #
    {for(i=1;i<=NF;i++){a[i,NR]=$i};m=NF;n=NR}
    END{for(j=1;j<=m;j++){
    for(k=1;k<=n;k++){printf("%s ",a[j,k])}print ""}}

    # outputs:
    #
    #
    # a e i
    # b f j
    # c g k
    # d h l



    Please Assist!!

  3. #3
    Join Date
    Feb 2008
    Posts
    4

    Converting a table from M*N to N*M in Access

    PS: if you want the actual table I can upload it tomorrow (7-8am EST)

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    The code in post 2 isn't VBA, so you can't implement it in Access.

    As for the rest of it, I'm kinda lost as to what you want to actually do. I get the gist of it, but without the context I can't really comment on what to do with Access.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Yeah - I'm not clear either. Could you post a screenshot of the report please? We may twig what you mean upon seeing that, but for belt and braces perhaps you could post a quick and dirty horizontal version of the report for comparison....

  6. #6
    Join Date
    Feb 2008
    Posts
    4
    I can do that... I am not able to access the Database untill tomorrow (Monday) though.

Posting Permissions

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