Calc's in report footer

[legendv]

I want to count the number of orders due for today at the end of a report. The report lists orders due for past future and present dates, but I want to count only the orders due for today.

So in the report footer there is a textbox with a control set as:
=IIF([orderdate]=Date(),Count([orderkey]),0)

There is at least one order that is due today, however it still results in 0 as a result. I'm not getting any syntax error msgs, but I'm not ending up with what I need.

Any suggestions?

 

[legendv]

Thanks Pat, again, and again, and again.