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

  • Thread starter Thread starter Roger
  • Start date Start date
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
 
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
..
 
Back
Top