How can I achieve this? I want to:
Sum the [Value] field, where [Active] field is True, OR where the [Invoiced] field is True. Here is my code so far, which is returning #Error
=DSum("[Value]","Jobs","[Active]=1" AND "[Invoiced]=1")
It works fine for one criteria, such as:
=DSum("[Value]","Jobs","[Active]=1")
But it wont work with the AND... can anyone tell me where this went wrong?
Sum the [Value] field, where [Active] field is True, OR where the [Invoiced] field is True. Here is my code so far, which is returning #Error
=DSum("[Value]","Jobs","[Active]=1" AND "[Invoiced]=1")
It works fine for one criteria, such as:
=DSum("[Value]","Jobs","[Active]=1")
But it wont work with the AND... can anyone tell me where this went wrong?