fredq,
I tried that but it wont show the count. That is as important as the count
itself. Visable=Yes but that still does not work.
:
On Mon, 3 Apr 2006 05:10:02 -0700, DDrowe wrote:
I want a block at the bottom of my report that give the total number of
records in that report. I found a "Count" function in the help section but I
can not get it to work or display.
Any help is greatly appreciated.
David
You want the count of the number of records in the report?
Add an unbound control to the REPORT Footer.
=Count(*)
To display the count in the PAGE Footer, add another unbound control.
Set it's Control Source to:
=[NameOfControlInReportFooter]
You tried 'it' where? In the Page Footer? In the Report Footer?
Was the visible property of these controls set to Yes? Was the Visible
property of the section the control is in set to Yes? Do you have any
code 'Cancel = True' in the section the control is placed?
Do you get the correct count and display in the Report Footer?
What are the names of these controls?
What are the EXACT expressions you are using?