View Full Version : Count MTD for Report Records


Lstclair55
08-15-2007, 11:36 AM
Hi,

I have a report with various field entries, I want to be able to count upwards from one (being the first record) to indicate a month to date number.

Any ideaS?

pbaldy
08-15-2007, 11:43 AM
Since this is in reports, you can have a textbox with a control source of

=1

and its running sum property set appropriately.

Lstclair55
08-15-2007, 11:57 AM
Is there a way to count the total number of record in a report in the page footer?

pbaldy
08-15-2007, 12:05 PM
=Count("*")

will work in the report footer.

Lstclair55
08-15-2007, 12:20 PM
I just get #error

pbaldy
08-15-2007, 12:22 PM
Sounds like it's in the page footer rather than the report footer. You typically have to use code to get data like that in page footers.

Lstclair55
08-15-2007, 12:39 PM
Even in the report foot, it asks me for a paremeter value

pbaldy
08-15-2007, 12:42 PM
Exactly what do you have as a control source?