I want to create a line chart on access 2003 between the time line
based on a query. The query results are the number of incident each
day. So the query result looks something like this:

1/1/2006 5
1/2/2006 3
1/4/2006 4
1/8/2006 7

The problem is if there is a gap between dates, the line chart wouldn't
go to zero. It would just jump from last data point to the next when
the time-scale axis is used. How do I make the line chart to go to zero
when there is no data for that date. Can someone please help?