INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

# count(iif,iif,value) is this and if? if so how do I do or if

## count(iif,iif,value) is this and if? if so how do I do or if

(OP)
Dear All,
Thanks for a great forum.
I have trawled the internet and found nothing I can relate to my problem.

I have a quarterly report for PS returns.
I have the following code to count if [DTYPNUMBCO] = "0013" etc.
But I want to count if the [DTYPNUMBCO] = 0013 or if the PPA is Y or if EIA = "Y" or if the Ext = "Y"

#### CODE --> Reports

=Count(IIf([DTYPNUMBCO]="0013",IIf([PPA]="Y",IIf([EIA]="Y",IIf([ExtTime]="Y",0)))))
so I want it to definitely test if it is the correct [DTYPNUMBCO] but the other counts are optional [PPA]/[EIA]/[ExtTime] (only if the condition is met)

Any help would be really appreciated

Thank you,

Kind regards

Triacona

### RE: count(iif,iif,value) is this and if? if so how do I do or if

Provide some sample data with the desired results.

I expect you are better off summing a true/false expression rather than counting.

Something like

#### CODE --> SQL

Sum(Abs([Color]="Green" AND ( Type="Shirt" or Size = "XXL")))

### RE: count(iif,iif,value) is this and if? if so how do I do or if

(OP)
Thanks I will try the Sum approach.
Thanks again

Thank you,

Kind regards

Triacona

#### Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

#### Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Close Box

# Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!