Showing value that a query doesn't catch

[danikuper]

I have a report that shows how a rep is doing in sales in a particular month. The sales of the rep are broken down by two lines of products (ProdA and ProdB). For example:

=======================
Rep..........Product.........Sales
JOhn.......ProdA...........$5,000
..............ProdB...........$3,000
Total John..................$8,000

Mary.........ProdA...........$4,000
...............ProdB...........$1,000
Total Mary...................$5,000
=========================

The problem is that sometimes the rep may not have sold a single product of one type on a particular month and my query then won't show it. The report ends up looking like the following:

=======================
Rep..........Product.........Sales
JOhn.........ProdA...........$5,000
Total John...................$5,000

Mary.........ProdA...........$4,000
...............ProdB...........$1,000
Total Mary...................$5,000
========================

Even if the rep has not sold any ProdB, I would like to thave that in my report as $0. So, for example, my report would show:

=======================
Rep..........Product.........Sales
JOhn.........ProdA...........$5,000
...............ProdB...........$0
Total John...................$8,000

Mary.........ProdA...........$4,000
...............ProdB...........$1,000
Total Mary...................$5,000
========================

Is there a way to do this?

Thanks for the help!!!

daniel