Access DSum Calculations adding a third optional criteria?

  • Thread starter Thread starter CHeins
  • Start date Start date
C

CHeins

I'm a access student trying to figure out how to add a third optional
criteria condition.

Here are my first two conditions - this works

=DSum"[TotalPledged]","[Donorpledges]")

when I add the third optional field it says error What am I doing wrong

=DSum"[TotalPledged]","[DonorPledges]", "[PaymentMethod=B]")
This problem is on page 362 is on the Microsoft Office Acess 2003 Textbook.
 
Back
Top