Counts in Queries (0 vs. null)

  • Thread starter Thread starter sue
  • Start date Start date
S

sue

How can I get a count to be "0" instead of null. Right
now, if my query returns no records (i.e. null) it causes
everything else on my form to be blank. I would like the
count to be "0" if there are no records. Any help would
be MUCH appreciated.
Thanks,
Sue
 
I guess that you are using a "Count" or "Dcount" function.
This is what I have done to check for null values.

sub TESTING ()
dim ctr as integer

if IsNull(Dcount("fieldname", "tablename", "criteria"))
then
ctr = 0
else
ctr = Dcount("fieldname", "tablename", "criteria"))
end if
end sub

Hope it helps.
 
Back
Top