Count MTD for Report Records

[Lstclair55]

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]

Since this is in reports, you can have a textbox with a control source of

=1

and its running sum property set appropriately.

 

[Lstclair55]

Is there a way to count the total number of record in a report in the page footer?

 

[pbaldy]

=Count("*")

will work in the report footer.

 

[Lstclair55]

I just get #error

 

[pbaldy]

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]

Even in the report foot, it asks me for a paremeter value

 

[pbaldy]

Exactly what do you have as a control source?