DSUM question

[fenhow]

Hi,

I am trying to run a DSUM using more than one variable.

Is this possible?

Here is the code I Have so far

=DSum("[Surface Acres]","QRY_MINERAL SUMMARY DSUM","[Mineral_Status]='Unit Designation HBP' and 'Title Received via Mineral Ownership Report'")

It does not error out but will not add the two values..

Any suggestions?

Thanks.
Fen How

 

[pbaldy]

You need to repeat the field:

=DSum("[Surface Acres]","QRY_MINERAL SUMMARY DSUM","[Mineral_Status]='Unit Designation HBP' and [Mineral_Status]= 'Title Received via Mineral Ownership Report'")

Though I wonder if you meant "OR". The field could never be equal to two different values. Or perhaps the second is supposed to be a different field?