Dcount Multibles

[Madmax]

Good Mroning,

Is there a way to DCount Multibles?


=DCount("*","[Personnel Information]","[prp-requires replacement] = -1"&"[PRP Position Status]='Certified' or 'postured to PRP position'")

is what I got and obviously having issues with. I basically want to count who has prp requires replacement check that are currently certified or postured.

[ssanfu]

Good Mroning,

Is there a way to DCount Multibles?


=DCount("*","[Personnel Information]","[prp-requires replacement] = -1"&"[PRP Position Status]='Certified' or 'postured to PRP position'")

is what I got and obviously having issues with. I basically want to count who has prp requires replacement check that are currently certified or postured.

Try

=DCount("*","[Personnel Information]","[prp-requires replacement] = TRUE AND ([PRP Position Status]='Certified' or [PRP Position Status]='postured to PRP position')")
'

[Madmax]

worked thank you!