Can you count textbox if not part of a table

[wx5chr]

I have a dynamic textbox on my report with the following control source: IIf([Next_Rev_Date] < Date(), &quot;OVERDUE&quot;, &quot;&quot
The textbox name is &quot;Overdue&quot;. Overdue is not a part of any of my tables.

I want to count each &quot;OVERDUE&quot; and place it in the Report Footer.

Is this possible?

 

[GingerR]

i found that you cannot - see your other post. i tried this first but kept getting #ERROR. so that's when i put it right into the query. then it worked. is there a reason you don't want to put it in the query? i don't see any problems with that.

g

 

[wx5chr]

I did end up redesigning my query and everything is corrected now. Thanks for all the help and quick responses from everyone.