First I'm not sure why you hae those joins if there are no conditions or fields being returned?
But you gonna want a left join to start with then put the filed name with in the count([fieldName])
So it will count 0 for nulls
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]