DSum with 2 “<>” criteria

[Lmens]

Please, can some one please tell me what’s wrong with my DSum function?

=DSum("[AprilVCOS]","VCOSmaster","[D_Level]<>'H.SCOTT'AND 'SurtiVacCalaDB'”) -- this excludes “H.Scott” but includes “SurtiVacCalaDB”

=DSum("[AprilVCOS]","VCOSmaster","[D_Level]<>'H.SCOTT'AND <> 'SurtiVacCalaDB'") –This retures “#Error”

What I want is the sum of all but 'H.SCOTT' and ‘SurtiVacCalaDB’

Always with much appreciation!

 

[MarkK]

=DSum("[AprilVCOS]","VCOSmaster","[D_Level] <> 'H.SCOTT' AND [D_Level] <> 'SurtiVacCalaDB'")

 

[Lmens]

Thank you!!

 

[MarkK]

You betcha.
Cheers,

 

[boblarson]

An alternative method which works well with more values but can work with even one is:

=DSum("[AprilVCOS]","VCOSmaster","[D_Level] Not In('H.SCOTT','SurtiVacCalaDB')")

Which makes it shorter since you don't have to repeat the field name for each value.

 

[MarkK]

Yeah, that's even tidier. Thanks Bob.