Use of Nz Function in expresion

[Guest]

I'm using a Crosstab query (from multiple tables) that columns represent
month value of the year and files represent cost in$, each month;query with
"Between Initial and Final Date" criteria(in chort format). I need to use the
query to make a graph with line tendence showing the xy points. But some of
the selected months, has not record registered because nothing appened, then
the line of graph doesn't show the point x:0 ang y:0 and do not consider the
month with no value; ovbiously, I need to show the month with "0" value. I
know that in this case I need to use Nz Function but I dont know where to
insert it.
I will appreciate any help.
Salutes from Osorno, Chile.

 

[Duane Hookom]

You should be able to create a table with every possible month and include
it in your chart's row source. Create a join that selects all records from
the month date table.