DSum Control

[Brogrim]

I have a yes no field called Advocacy in a table called tblMemberServices, there is also a field in the table called ROCID.

I want to be able to count the advocay field that is true.
What is wrong with the following code.

=Abs(DSum("[Advocacy]","tblMemberServices","[ROCID] =" & Form!frmReports!ROCID))

Thnsk in advance

 

[Remou]

Is ROCID text or numeric?

 

[Brogrim]

Hi Remou

Thanks again for the help

ROCID is Numeric

Does numeric mean it is enclosed by quotes

 

[Remou]

No, text is quotes. I think you need to say a little more, such as in what way is it not working?

 

[Brogrim]

I am getting a Name error on the control when i preview it, what other info are you looking for.

 

[Remou]

That's fine, it could have been #error. I think that you are missing an 's' Forms, not Form:
Forms!frmReports!ROCID

 

[Brogrim]

Working perfect, could you direct me some where to learn synthax.

Thanks alot for the help

 

[Remou]

There are a few suggestions in this post:
DoCmd ?
thread702-1146655