include null count in total query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wayne-I-M - 18 Mar 2007 18:34 GMT

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

Signature

Wayne
Manchester, England.

Reply to this Message

Wayne-I-M - 18 Mar 2007 19:26 GMT

It's OK - I got it.

Signature

Wayne
Manchester, England.

Reply to this Message

strive4peace - 18 Mar 2007 20:22 GMT

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
*

> It's OK - I got it.

Reply to this Message

Wayne-I-M - 18 Mar 2007 20:32 GMT

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

:-)

Signature

Wayne
Manchester, England.

> glad you got it, Wayne -- doesn't it feel good when you can answer your
> own questions? :)
[quoted text clipped - 10 lines]
>
> > It's OK - I got it.

Reply to this Message