#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Jan 2013
    Posts
    1
    Rep Power
    0

    Angry Cross Tab With Multiple Rows And Date Headers...Help!


    I am trying to recreate this table in MS Access using a cross tab query but not having any success.
    How can I get this done because I am at a loss. Help!

    OPEN Date 9/1 9/2 9/3 9/4 9/5
    VOLUME 92 80 138 2524 2063
    COMPLETE 61 65 108 1505 1179
    PASS% 66.3% 81.3% 78.3% 59.6% 57.1%
    FAIL 31 15 30 1019 884


    Any information would be greatly appreciated.
  2. #2
  3. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    58
    It's hard to give an accurate answer because we know absolutely nothing about your data, but from what I do see, I do not believe what you want to do is possible. The total fields in a cross tab query must be uniform. (you can only select one total field in a crosstab query) They're always going to be the same calculation or data field from your table or query. Also it should be noted, that while you can use dates in your crosstab query, you can't use them on a report or if you place your query in a subform.
  4. #3
  5. Moderator
    ASP Super Genius (4500 - 4999 posts)

    Join Date
    Apr 2009
    Location
    The Great Land
    Posts
    4,618
    Rep Power
    649
    I won't say 'not possible' but instead 'not easy'.

    Do 5 crosstabs and then either join them on common unique ID (results in one record) then arrange the fields in report to have the appearance of 5 records or UNION the crosstabs to show 5 records.

    Stabilizing a crosstab to run perpetually in report can be tricky, especially when pivoting on date value. Review:
    http://www.rogersaccesslibrary.com/f...-e7d44b7z.html

    As meratigoerr says, need better understanding of data to give better advice.
    Last edited by June7; January 18th, 2013 at 04:12 PM.
    I like to know if my suggestion helped you. One way to let me know is by clicking star at bottom left corner of post.
    Debug!Debug!Debug!http://www.cpearson.com/excel/debug.htm
  6. #4
  7. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    58
    June, I had never considered the idea of a union on crosstab queries. I'm definitly going to have to give it a try.

Similar Threads

  1. Multiple rows into one row / multiple columns
    By weslake77 in forum Microsoft Access Help
    Replies: 6
    Last Post: May 17th, 2012, 12:23 AM
  2. Cross Tab Query with mulitple column headers
    By ygreen in forum Microsoft Access Help
    Replies: 2
    Last Post: September 21st, 2010, 09:33 AM
  3. Host headers, multiple domain names one ip address
    By Do Work in forum Microsoft IIS
    Replies: 1
    Last Post: October 24th, 2008, 03:19 AM
  4. Print headers in subform on multiple pages
    By sp3 in forum Microsoft Access Help
    Replies: 0
    Last Post: August 10th, 2006, 09:40 AM
  5. Importing from Excel - Date Headers
    By scottst in forum .NET Development
    Replies: 2
    Last Post: February 27th, 2005, 07:53 PM

IMN logo majestic logo threadwatch logo seochat tools logo