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
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Blank or Null in a Cross Tab Query in Access 2003 2
Sorting in a Cross Tab Query 2
Format column headings in Cross-Tab 1
cross tab query outer join 1
Cross Tab Query with DataSerial 2
Cross tab query solution 4
Cross-tab to look like Calendar 1
Cross Tab Query with two values 1

Back
Top