Null Query Results

  • Thread starter Thread starter Frustrated
  • Start date Start date
F

Frustrated

Hi All:

I've got a query driving a text box on a form (and me
nuts!). Here's the SQL statement for it:
The pop up form has one text box on it bound to this
query:
SELECT Count(tblRequests.RequestID) AS CountOfRequestID,
tblRequests.Approve, tblRequests.Deferred
FROM tblRequests
GROUP BY tblRequests.Approve, tblRequests.Deferred
HAVING (((tblRequests.Approve)=No) AND
((tblRequests.Deferred)=No));

My problem is that if there is no count the query returns
a null. How can I make the results be zero rather than
null?

Thanks
 
Back
Top