include null count in total query

W

Wayne-I-M

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

Wayne-I-M

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

To Include Count In Crosstab Query 1
Run Macro if Query is Not Null 4
Totals Won't Count Nulls 1
Missing attendance records (Wizard won't help) 3
Blank or Null in a Cross Tab Query in Access 2003 2
display a count in a query when null 4
Calculating a ratio based on letters in a field 5
grouping issue with ' is not null ' 1

Top