Use of Nz Function in Access 2000

[Guayo]

I’m constructing a Line Tendency Graphic in a Database of Access 2000, from a
Crosstab Query with Columns showing Months of a year and File showing Costs
($) of the desired months with “between Initial and Final Date†criteria
(Chort format). The problem is, the Line Tendency of the graphic doesn’t
shows the months with no records due to these desires months there weren’t
records to register; but I need the Tendency Line shows those as “0â€; I need
to know that. I know the Nz Function solve my problem but I don’t know how
and where to insert it.
Guayo, requiring help from Osorno, Chile.

 

[Guest]

You need to create a query with records for every month.
You might join to a month table, or create dummy records.
If you have dummy records, you can put them in as 0.
If you join with a month table, the missing records will have
a value of NULL. The NULLs can be converted to zero's:
in a query by creating a new field like this:

nCosts: NZ([mCosts],0)

(david)

 

[Guayo]

Thanks David; I'll try to do that.

You need to create a query with records for every month.
You might join to a month table, or create dummy records.
If you have dummy records, you can put them in as 0.
If you join with a month table, the missing records will have
a value of NULL. The NULLs can be converted to zero's:
in a query by creating a new field like this:

nCosts: NZ([mCosts],0)

(david)

I'm constructing a Line Tendency Graphic in a Database of Access 2000, from a
Crosstab Query with Columns showing Months of a year and File showing Costs
($) of the desired months with "between Initial and Final Date" criteria
(Chort format). The problem is, the Line Tendency of the graphic doesn't
shows the months with no records due to these desires months there weren't
records to register; but I need the Tendency Line shows those as "0"; I need
to know that. I know the Nz Function solve my problem but I don't know how
and where to insert it.
Guayo, requiring help from Osorno, Chile.