Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: Problem with chart in Access

Discussion in 'Information Technology' started by Guayo from Chile, Jul 28, 2006.

  1. Guayo from Chile

    Guayo from Chile
    Expand Collapse
    Guest

    Betsy:
    Sure, I can but, I need the engine recognize automaticly the month that
    hasn't record, then insert a blank cell for these month into datasheet and
    then microsoft graph can transform blanks cell in "0" and show it in the
    chart. So, I need a VB code or SQL expression in order to tell the engine
    what I want.
    Did you get it Betsy?

    "betwalk@gmail.com" wrote:

    > Guayo from Chile wrote:
    > > I'm creating an access database. I'm trying to get a lineal graph showing in
    > > X categories the each months and Sum of count incidents registered in Y
    > > categories, both, between some initial and final date indicated in dialog
    > > form. The graph gets de records from a Select Query, from some tables that
    > > one of it has an ID and date camp in dd-mm-yy format. Any time that occur an
    > > incident, I must to insert the date when occur. The problem is: if I select a
    > > period like Jan to Apr and I have records for Jan, Mar and Apr only, the
    > > lineal graph shows points for just the month Jan, Mar and Apr but not for
    > > Feb, where it hasn't records because nothing happened in these month but; I
    > > need the graph shows the point Feb as 0 incident any way. How con I solve the
    > > problem?
    > > Please, help me any body has the answer!
    > > Guayo from Chile.

    > -----------------------------------
    > Hello Guayo-
    >
    > Can you enter a record for February showing zero activity?
    >
    > Betsy
    > -----------------------------------------
    >
    >
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikhs Face Problems While Carrying Kirpans In Khyber-Pakhtunkhwa - SikhSiyasat.Net Breaking News Jul 29, 2016
    "Dasam" Granth - A Look At The Core Problems Dasam Granth Oct 21, 2015
    Problems In Life Sikh Sikhi Sikhism Apr 13, 2015
    How can I make decent and useful friends and from where ?? most people have a problem with me Sikh Youth Oct 23, 2013
    The Problem with Taking Too Many Vitamins Health & Nutrition Oct 18, 2013

  3. betwalk@gmail.com

    betwalk@gmail.com
    Expand Collapse
    Guest

    Well, I guess I don't get it.

    If you enter a record for February showing zero activity, then it will
    already be in the data. I see no need for code. The report would
    reflect the "0" you provide in your data. I tried it and it worked
    just fine.
     

Share This Page