Use of Nz Function in Access 2000 Crosstab Query

[Guest]

I'm working in an Access Database. I'm constructing a Line Tendence Graphic
with records from a Crosstab Query (CTQ) and this one from Costs Table and
Count of Incidents Table. The columns of the CTQ show Months of a year due to
criteria "Between Initial date and Final date" of a Dialog Form and File of
the CTQ shows the sum of the Costs. My problem is the Cost and Count of a
desire month is "0" because it were not incidents and costs in this month;
then the Line Tendence of the Graphic doesn't shows the month with "0"
records but, I need the Graphic shows it. I know that I need to use Nz
Function in order the CTQ and Graphic transform Null records to "0" and then,
to show it, but I don't know how and where to insert it.
Guayo, requering help from Osorno, Chile.

 

[[MVP] S.Clark]

I would think that you would need an Outer Join. So, have a months table,
and outer join it to the incidents table. That way, you get all the months
for each query. Use the ColumnHeadings property of the query, too.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

 

[Guest]

Steve:
You must know that my database doesn't use a table to register the date
(day, month and year) of the incident; just a text control(chort date format)
in the Incident Table.