Count IIF Statement?

5 pts.
Tags:
IIF
IIF function
IIF statement
Microsoft Access queries
Query Design
In the design of a query, I noticed that under the tab "Group By", there are only a few types of commands to make calculations. For example, the commands include Sum, Avg, Min, Max, Count, StDev, Var, First, Last, Expression, Where. Is it possible to have a special command? I'd like to use countif(field>0) instead of just counting the number of all the fields.

Software/Hardware used:
Microsoft Access

Answer Wiki

Thanks. We'll let you know when a new response is added.

Why not put the criteria of field>0 in your criteria? Then you will only be counting rows where field is > 0

–msi77–
Use the following:

<pre>sum(IIf(field>0,1,0))</pre>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following