Results 1 to 4 of 4
  1. #1
    Join Date
    May 2009
    Posts
    29

    Unanswered: Graph Issue in Access Report

    Hello all,

    Need some help...this just has to be an option...i just cant figure out how to build the statement.

    Have a Query... qrySRbyHour has the follwoing fields:
    SR#
    Hour
    Date
    Owner
    Type

    What I want to do is have bar graph with the X axis the hours (0-23) plotted along and have it total up the total # of SR# (tickets) by type.

    So..there are 2 types...Email and Phone...all reported in the Column of Type.

    I can get a basic graph giving the WHOLE total by using:
    SELECT [Hour],Count([SR #]) AS [SRCount] FROM [qrySRbyHour] GROUP BY [Hour];

    But what I would like is a Stacked graph (prefer) showing the totals by hour for each SR Type in one graph....any ideas???

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    Crosstab the Hours and count the SR# groupby the Owner or type

    that create new coloums of hours 0-23 and and rows will have the groupby value
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    May 2009
    Posts
    29
    Sorry...not sure I understand how this will translate into a graph. Additionally...I tried creating the CrossTab Query based on what you said and I get a MisMatch.

    I CHose Hour as Row Headings, Type as Column Heading, and then Count SR# as the data to be calculated....when I try to run the Query i get a data mismatch

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    HMMMMMMMM
    Data mismatch

    is the "Type" a feild name in the database

    msaccess could be having problem with that
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

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