include null count in total query

G

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
 
S

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
*
 
G

Guest

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

:)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show null values in Query 0
Append Query 2 4
display a count in a query when null 4
To Include Count In Crosstab Query 1
Count Null fields 2
Run Macro if Query is Not Null 4
Check for Null Or 0 in Delete Query 4
UNION query splitting columns 10

Top