include null count in total query

[Guest]

Is there a way to include null values in a totals query.

tblCharity
charityID = eg. a b c d

tblEvent
eventID = eg. w x y z

tblbookings
charityID
eventis

I am trying to run a totals query to show "all" events and charities with a
count of particpants

Charity
event w = 2
event x = 0
event y = 3
event z = 0

Of course the problem is the 0 as you can't count null records.

How do I include all events and charities and include 0 for null

Thanks

 

[Guest]

It's OK - I got it.

 

[strive4peace]

glad you got it, Wayne -- doesn't it feel good when you can answer your
own questions?


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Guest]

I think it more like thinking - why did I agree to make this DB for free
(it's my charitable side coming out)