DSum problem

[Brogrim]

Hi all

I am trying to count the number of supports that are ticked Yes in the MemPOMInt Table. The criteria is the MemPOMID control that is on the form.

=Abs(DSum("[Support]","tblmempomint","[mempomid] = Me!MemPOMID"))

Thanks in advance

 

[Remou]

Perhaps:
[tt]=Abs(DSum("[Support]","tblmempomint","[mempomid] =" & Me!MemPOMID))[/tt]
Assuming that MemPOMID is numeric. You need some single quotes, if it is text:
[tt]='" & Me!MemPOMID & "'"[/tt]

 

[Brogrim]

Tried that but I had my reference wrong on the form syntax


=Abs(DSum("[Support]","tblmempomint","[mempomid] =" & Form!frmMemPOM!MemPOMID))

Thanks for the help.