DCount Function

[DaniBoy]

Need help with Dcount "Urgent" need this report

Hello
I have a report made from a query called ResponseDetail where I have 6 fields that the report uses. 2 of the fields are dates and 4 are checkboxes. The name of the query is ResponseDetail and one of the checkbox name is "Bulk" I need to tell access to only count de records on the checkbox that are true. This is what I did and it gives me errors;
=DCount("[Bulk]","ResponseDetail","[Bulk] = -1'")

 

[Rich]

Sum(Iif([Bulk] = True,1,0))

 

[DaniBoy]

Thanks Rich

It works when I use it on the detail section, but I want to be able to use it on the page header. When I put it there the data is an error. Any more ideas?
Thanks
DaniBoy

 

[DaniBoy]

Anyone else has any idea how to do the above?!!
Thanks

 

[AccessPhantom]

Place unbound textbox in the page header.
Set the control source to the textbox containing the result from the detail section (from the formula suggested by Rich).

Phantom