Hello
I'm trying sum a field with multiple criteria
Here's what I have tried
=dsum("[2020]","resources","[Role ID]"=text124 and "[ref no]"<>9999)
It is to sum column "2020" in the "resources" table WHERE "Role ID" equals the value in "text124" AND "ref no" does not equal "9999".
Much appreciated
I'm trying sum a field with multiple criteria
Here's what I have tried
=dsum("[2020]","resources","[Role ID]"=text124 and "[ref no]"<>9999)
It is to sum column "2020" in the "resources" table WHERE "Role ID" equals the value in "text124" AND "ref no" does not equal "9999".
Much appreciated