Use of Nz Function in a Crosstab Query

[Guest]

Yesterday, I send a mess to discussion groups but it doesn't appear. I'll do
it again.
I'm working with a Cosstab Query(from miltiples tables); columns are Months
and Files are Sum of Cost($) of damage in each month. I need this CtQ in
order to use it for a line tendence graph. Because some Month it hasn't
record to register, the respected column in the CtQ has Null Value then, the
line tendence of the Graph doesn't consider this month and jump to the next
month with records; but I need that the line tendence of the graph shows the
month with no records, like a "0" record.
I know that I have to use Nz Function for that but, i don't know where and
how to insert it in the CtQ or another way to force the Graph to show the "0"
value for the month with no records.
Guayo requesting help from Osorno, Chile.

 

[Dave Patrick]

Duane Hookum answered you.
http://groups.google.co.uk/group/mi...bject:expresion&rnum=1&hl=en#d2ae9e9e23e0fcb9

This may also help.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart05/html/sa05d1.asp

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Yesterday, I send a mess to discussion groups but it doesn't appear. I'll
do
| it again.
| I'm working with a Cosstab Query(from miltiples tables); columns are
Months
| and Files are Sum of Cost($) of damage in each month. I need this CtQ in
| order to use it for a line tendence graph. Because some Month it hasn't
| record to register, the respected column in the CtQ has Null Value then,
the
| line tendence of the Graph doesn't consider this month and jump to the
next
| month with records; but I need that the line tendence of the graph shows
the
| month with no records, like a "0" record.
| I know that I have to use Nz Function for that but, i don't know where and
| how to insert it in the CtQ or another way to force the Graph to show the
"0"
| value for the month with no records.
| Guayo requesting help from Osorno, Chile.