Calculated Control Code

[aandress]

Can anyone tell by looking at this code what might be wrong with it?

=DSum("[AccumulatedValue]", "Client Account Summary", "[Managed] = 'Yes'")

I am trying to add the values in the accumulated value field in the Client Account Summary Form if the Managed field is clicked to yes. I have it in the control source for the the text box but it only returns a #Error.

Help? Thanks!

 

[SimonC]

Remove the single quotes from around the 'Yes'. That should do it.

Simon