I have:
DCount("[Role]","NBOI","[Paragraph Description]='" & [Paragraph Description] & "' AND [TOE Paragraph Num]='" & [TOE Paragraph Num] & "' AND [BN (Operating)]='" & [BN (Operating)] & "' AND [base]='" & [base] & "' AND [Platform]='" & [Platform] & "' AND [Role]='" & [Role] & "' AND [NBOI Sort Order (int)]<" & [NBOI Sort Order (int)]+1)
I want to add: IIF[Platform]='Soldier", [Platform]='" & [Platform], '')