Notices

Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

Thread: Cross Tab With Multiple Rows And Date Headers...Help!

Results 1 to 4 of 4
Share This Thread →
  1. #1
    nfoserv is offline Registered User
    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
    meratigoerr's Avatar
    meratigoerr is offline Contributing User
    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.

  3. #3
    June7's Avatar
    June7 is offline Moderator
    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

  4. #4
    meratigoerr's Avatar
    meratigoerr is offline Contributing User
    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.

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

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

ASP Free Advertisers and Affiliates