2 Value in Criteria (1 Viewer)

eyeseven · Sep 30, 2014

Hi.. i'm trying to filter from dsum criteria the two values, here is my code :

Code:

=DSum("Amount","qry_sumawpo","[Status] = 'FBLNG'" OR "[Status] = 'BLLD'")

please help me to correct this code.

I need 2 different values in 1 criteria.

pr2-eugin · Sep 30, 2014

Try this one.

Code:

= Nz(DSum("Amount","qry_sumawpo","[Status] = 'FBLNG' OR [Status] = 'BLLD'"), 0)

eyeseven · Sep 30, 2014

pr2-eugin said:
try this one.

Code:

= nz(dsum("amount","qry_sumawpo","[status] = 'fblng' or [status] = 'blld'"), 0)

wow! It works!

thanks so much!