Linked count queries / One null query blanks out all the rest.

[aldo]

Hi all,

I've tried the ‘is null, '=0" and ‘nz’ routines on the Count(Tablename.Fieldname)'s, but can't seem ‘to get them to output a value of 0 in the null fields. I must be doing something wrong. Any and all help would be very much appreciated.


Thanks much,
aldo

 

[Simon_MT]

I approach these type of queries with the view I want something rather than nothing. So in my subordinate queries starting from (your Example) Household so that HouseholdID is in every query and Left Joined to Members etc. Evaluate what to do with Nulls perhaps zero. It not longer matters whether or not the tables are populated.

Simon

 

[aldo]

Thanks Simon.

I was hoping for a simple fix here. Not a problem though. I reworked the query and broke it down into a few separate queries and it works great now.

-aldo