How to Give more than one Not Equals to Operator in a Report? (1 Viewer)

[JithuAccess]

Hello Guys,

I want to find the Sum of the Payment if the Program is Not Equals to "M" Or "H" and I have given this Code

=Nz(DSum("[curTotal Paid]","[tblPayments Final]","strProgram<>'M' Or 'H'),0)

But I am getting an Incorrect Result.

I think the Logic is wrong.

Could you guys please help me how to fix this?

Thanks

 

[The_Doc_Man]

=Nz(DSum("[curTotal Paid]","[tblPayments Final]","strProgram<>'M' Or strProgram <> 'H'),0)

The problem is that the ENGLISH word OR doesn't have the same exact meaning as the COMPUTER operator-symbol OR.

In English, OR is a conjunction. In Computerese, OR is an action verb.

 

[JithuAccess]

=Nz(DSum("[curTotal Paid]","[tblPayments Final]","strProgram<>'M' Or strProgram <> 'H'),0)

The problem is that the ENGLISH word OR doesn't have the same exact meaning as the COMPUTER operator-symbol OR.

In English, OR is a conjunction. In Computerese, OR is an action verb.

Thanks a lot. I fixed it. I used "Is Null" and it worked Perfect. In my Programs Fields there are 3 Values "M", "H" and Blank (Null) I want to find the total of Blank (Null) and I use this code:

=Nz(DSum("[curTotal Paid]","[tblPayments Final]","strProgram Is Null),0)

Thank You

 

[theDBguy]

=Nz(DSum("[curTotal Paid]","[tblPayments Final]","strProgram<>'M' Or strProgram <> 'H'),0)

The problem is that the ENGLISH word OR doesn't have the same exact meaning as the COMPUTER operator-symbol OR.

In English, OR is a conjunction. In Computerese, OR is an action verb.

Pardon me for jumping in, but just to clarify for future readers, using OR would sum all the records because M<>H and vice versa.

In this case, I think we would want to use the AND operator.

 

[The_Doc_Man]

Good point, tDBg, that's what I get for shooting from the hip.

 

[Gasman]

Missing " from end of criteria, so how did that work?