Count IIF with multi values

[harpreett.singhh@gmail.co]

Hi,



I want to count the records with multi iif conditions. I am able to get one condition right but don't know how to put more than 1.

Eg: =Count(IIf([Step #]=1 And [Type of Work]=1,0))

But I am not able to get if I want step#1, step#2 and step#3 all together with type of work = 1

Please help

[June7]

Not sure what you want.

Is [Step #] the name of a field? You want to count records where [Type of Work] = 1 AND [Step #] = 1 or 2 or 3? Are there other values?


BTW, advise no spaces or special characters/punctuation (underscore is exception) in naming convention. Better would be StepNum, StepNo, Step_Num.

[harpreett.singhh@gmail.co]

Hi,

Yes Step# and type of work are field names from a table. step # are about 15 and type of work are 2 (TW and PW)

Thanks for the suggestion reg the field names.

Regards

[June7]

Didn't answer question about what data you want to count.

Maybe:

Sum(IIf([Type of Work]=1 AND ([Step #]=1 Or [Step #]=2 Or [Step #]=3), 1, 0))

or

Sum(IIf([Type of Work]=1 AND Not IsNull(Choose(Nz([Step #],0), 1, 2, 3)),1 ,0))

[harpreett.singhh@gmail.co]

Hi,

i want to count the records with below situations

* step # is 4,5, 6 & 7 and type of work is 1
* step # is 8,9,10,11 & 12 and type of work is 1

similarly both above sitautions with type of work = 2

i will try ur above given syntax tomm.

thanks for ur time.

regards

[harpreett.singhh@gmail.co]

I tried the option 1 and its working. Thanks a lot June7. Cheers.