Null Query Results

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Parameter Crosstab query filter by form 1
Totals Won't Count Nulls 1
Null Criteria Problem 4
Select Top with aggregate function 1
Crosstab query results and null vs. zero values 1
Query driven by form field 1
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
result query on a form 1

Top