Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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

    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

    Expand Collapse

    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.
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page