counting entries in an unbound control

[netooi25]

I'll try to explain a basic example that will help me with what I need.

In the detail section of a report, I have an unbound text box called txtDetail

In the footer, I need to count the number of entries in the txtDetail box.

If it was a bound control, I believe i could just use Count(txtDetail).

However, since it is an unbound control, I dont believe you can use aggregate functions.

Any suggestions?

Thanks for any help

 

[Crowley16]

hows about the old:

=sum(iif(tbxDetail='Blah', 1, 0))

--------------------
Procrastinate Now!

 

[netooi25]

hmm, it asks me to enter a parameter value for txtDetail, as if it doesnt recognize it is on the report

is this because its in a different section on the report?

 

[netooi25]

I also might should add I calculate the value
of the txtDetail field in the detail_format event..

If this helps any