Intersection point in line graph

[Guest]

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.

 

[Arvin Meyer [MVP]]

You can add a table of months and do an Outer Join (in Access this is called
a Left or Right Join).

You can also do a Crosstab query and force the column heads (right-click on
any blank area of the query grid and choose: Properties) Type in the Months
(surrounded by quotes and separated by commas). That will give you an empty
column for February.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access