i want to count of all entries inside specefic date i got it done my problem is i want to put an aumaticay 0 (zero) when no data is found... the source data is from the table i did this querry in an data querry.. the reason why i want to put zero because this field call by the other querry also which is need for mathematical calculation when the selection has no data found it's totally blank the result is the other compution get error because there is no number found.. that is why i want put zero (0) when there no data found..

please help..
my database is access 2003
here is my code
Code:
SELECT DISTINCT (mydate)
FROM ttmcall
WHERE mymonth='12';