Results 1 to 5 of 5
  1. #1
    beat is offline Novice
    Windows Vista Access 2003
    Join Date
    Dec 2011
    Posts
    9

    Arrow I need Access to create a excel table like output

    Dear Friends of Access,

    Since this forums helped me out before, I have another request for you. I did all the analysis. My final query looks as follows

    Jan_N-1, Feb_N-1, Mar_N-1, Jan_N-2, Feb_N-2, Mar_N-2
    0.98......... 0.90..... 0.88....... 0.95....... 0.88...... 0.70


    but I need Access to create a excel table like output. which looks as like

    .......Jan. Feb. Mar
    N-1 0.98 0.90 0.88
    N-2 0.95 0.88 0.70

    Anybody any suggestion? That would be great!
    Greetings from Hongkong

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    That is a query with 6 fields? Is it the result a CROSSTAB query?

    You could build a report that arranges the textboxes in that order.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    beat is offline Novice
    Windows Vista Access 2003
    Join Date
    Dec 2011
    Posts
    9
    thanks for the reply. yeah 6 fileds. i dunt really know what a crosstab is. I know that i can arrange the textboxes but this seems to vague i am not sure that this is a good way if i have to work with the data later on. since i have to apply this methods on bigger queries which then containing 30+ fields and i have doubts that i can export the data properly to excel.

    Id like sth like a table where you can put certain values in this column and certain values in another.

    is this possible?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Crosstab also know as pivot or transpose.

    A UNION query could accomplish this. There is no query designer or wizard for UNION, must type in the SQL View window.

    SELECT "N-1" As Category, Jan_N-1 As Jan, Feb_N-1 As Feb, Mar_N-1 As Mar FROM queryname
    UNION SELECT "N-2", Jan_N-2, Feb_N-2, Mar_N-2 FROM queryname;

    Limit of 50 UNION lines in one query.

    If you want to provide sample of source data and the SQL statements that arrived at this will try to determine if another approach possible.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    beat is offline Novice
    Windows Vista Access 2003
    Join Date
    Dec 2011
    Posts
    9
    Thanks man. UNION query is exactly what i needed. works great.

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

Similar Threads

  1. Display MULTIPLE tabs on EXCEL output from FORM
    By taimysho0 in forum Programming
    Replies: 8
    Last Post: 12-12-2011, 02:07 PM
  2. Output Report to Excel
    By BLD21 in forum Reports
    Replies: 5
    Last Post: 04-26-2011, 07:53 AM
  3. Formatted Excel Output
    By jerryrs in forum Import/Export Data
    Replies: 6
    Last Post: 02-26-2011, 11:58 PM
  4. URGENT HELP: output to excel
    By jerryrs in forum Import/Export Data
    Replies: 1
    Last Post: 12-22-2010, 12:18 PM
  5. Replies: 4
    Last Post: 10-03-2010, 09:54 PM

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