Count Query with no values

[The Pikey]

I have a Select Query which amalgamates four different Count queries into
one. The problem i'm having is that if one of the Count queries hasn't
returned a value then the Select query doesn't return any values at all.
I've tried entering several permuations of "Is Null" in the criteria for the
two count queries which could have no values, but to no avail. Any advice
would be helpful.

 

[JohnFol]

when you "alamgamate" the 4 different queries into 1, you must be using a
join. Make sure the join allows Null values from the tables that have no
matching records. You can then do an

iif (IsNull(MyQuery1!Count), 0, MyQuery1!Count)

or have a look at the DCount / DLookup functions.

 

[The Pikey]

The 'iif' statement worked fine.

Thanks for the help.