Access DSum Calculations adding a third optional criteria?

[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.

 

[Tom Wickerath]

Hi CHeins,

Try this instead:

=DSum ("TotalPledged","DonorPledges", "PaymentMethod='B'")


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[the user]

dick