HELP - Chart with zero value

luigen

New member
Local time
Today, 19:32
Joined
Apr 2, 2007
Messages
9
Hi guys. First of all my english is too bad. So, i'm an italian user of Access and I have a BIG (for me!!!!) problem with a Chart.
The Query extract this data:

DataV SommaDiEur_2
02/01/2007 45200
03/01/2007 26400
04/01/2007 3600
05/01/2007 8400
08/01/2007 32800
10/01/2007 9200
11/01/2007 1600
12/01/2007 400
15/01/2007 43600
16/01/2007 1200
17/01/2007 26800
18/01/2007 4400
19/01/2007 6000
22/01/2007 32000
24/01/2007 14800
25/01/2007 8000
26/01/2007 8800
29/01/2007 32800
31/01/2007 25600

The Query is:
SELECT DISTINCT Importi.DataV, Sum(Importi.Eur_2) AS SommaDiEur_2 FROM Importi GROUP BY Importi.DataV HAVING (((Sum(Importi.Eur_2))<>0) AND ((Year([Importi]![DataV]))=2007) AND ((Month([Importi]![DataV]))=1)) ORDER BY [Importi]![DataV] ASC

The chart, includes some data that not appear above (06/01/2007 and 07/01/2007 for example)

Can everyone help me to display the chart without value zero data?
Thanks
 

Attachments

  • chart.GIF
    chart.GIF
    68.4 KB · Views: 149

Users who are viewing this thread

Back
Top Bottom