how can I put [Count] in a text box ?

R

Roger

I have =count("*") in a report and want it inside text in a text box, ie
="On this page there are "&[Count]& " clients listed"

when I put text after the count function it is fine, but when I embed the
count function in the middle it won't work, what am I doing wrong ?

thanks ... Al
 
J

John Spencer

Try the following.

="On this page there are "& Count(*) & " clients listed"

That may work depending on where you are trying to use it. For instance, I
don't believe this will work in a page header or page footer.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
K

Klatuu

I believe John is correct. It may be that you will have to use two labels
and a text box.
 
Top