Forcing empty rows to print in access query

[Paul K]

I am new to working with Access 2003. I have created a query that counts the number in incidents by month (columns) by type of incidents (rows). The query works fine, except my problem is that if a particular type of incident had no activity for the year, that particular row does not show up at all. I'd like it to appear with all zeros showing by month. I've figured out how to show zeros in a particular month is the row does apprea if there is something for another month using the NZ function. But am lost if there is no activity at all for the year and the row does not show, but I still want the row to show. Thanks in advance for all of your help.

[debasisdas]

You can make access to display '123' in place of 'ABC', but for that there should be some data in the database. If there is no data what will be converted to display as 0. Try to achieve the same from the front end tool.