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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9518-re-problem-with-chart-in-access.html
> > one of it has an ID and date camp in dd-mm-yy format. Any time that occur an
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9518
> > 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
> -----------------------------------------
>
> 
Our Donation Goal
: Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters 
Linear Mode
