Count Boolean True(Yes) Records from Table and report on Unbound Form's Textbox

[Bluecider]

So, this should be simple right?
But I'm going crazy trying to work this out and have done over an hour of searching online, whits end...

I'm trying to take a count of records that have a checkbox checked (Yes/True) and return this total to a textbox on an unbound form by using the CONTROL SOURCE property of the textbox.

Underlying Table and Field:


tbl_JOBS = Table
Interviewed = Field (Boolean yes/no)

What do I put in the Unbound Form's Control Source property to return what I want? I've tried things like this to no avail: =Abs(Sum(IIf([tbl_JOBS]![Interviewed]=Yes,1,0)))

I just keep getting #ERROR in the textbox...

[John_G]

Did you try the DCount function?

=Dcount("*","[TblJobs]","Interviewed = True")

In your original expression, the error is in using "Sum" - Access does not have a "Sum" function (though SQL does)

[Bluecider]

=DCount("*",[tbl_JOBS],"Interviewed = True")

This returns in the textbox: #Name?

[John_G]

See my correction -

It should be =Dcount("*","[TblJobs]","Interviewed = True") - quotation marks around the table name.

[Bluecider]

Thanks. That works. I could have sworn I tried the Dcount statement above in one of my attempts, but maybe I had something small off.
Thanks muchos!