Cross Tab Query: "0" in null box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

I have a cross tab query that lists incident categories for the row heading
and months of the year for column heading. Not every indent type occurs every
month so there are blank in the resulting table. How do I have the table
print zero's ("0") instead of blanks?

Thanks,
YYY
 
Well, it always helps if you post the SQL of your query. That helps get you
a specific suggestion. I'm guessing that you are counting incidents and not
summing the cost of the incidents.

You probably need to change the first line to read something like
TRANSFORM CLng( Nz(Count(YourField),0)) as Result
SELECT ...


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top