IIF statement 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?

 

[ajdesalvo]

Try this:

=Dcount("[orderkey]","ReportRecordsource","[orderdate] = Date() &quot

Good luck! Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[legendv]

Anthony,

It worked!!!!! (but you already knew it would didn't you?)

Thank you!!!!!!!!

I tried puting the txtbox IIF in the detail section and then summing the count, but that didn't work either... thank you so MUCH!

Jon