Problem with counting zero records

[dgirl1010]

I'm working on a report that will show me the number of projects I have by phase. There are some phases that no projects are in, and I need to be able to display a zero count on the report for them.

I've tried using Sum(IIf([ProjectStage],1,0)), but I still don't get any zero counts. Help!

 

[TheAceMan1]

How are ya dgirl1010 . . .

Try:

[blue]   Sum(Nz([ProjectStage],0))[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[dgirl1010]

Hmm, that gave me a type mis-macth error. But I did figure something else out that works, I just did a left join to include all the records from the table where I keep a list of the phase names. Love it when it's something simple like that! Thanks!