Counting distinct with running totals

liddlem

Registered User.
Local time
Today, 21:28
Joined
May 16, 2003
Messages
339
Hi All
I remember reading a tut on how to count records using Running totals in a report - but I cannot remember where I read it.
It went something like this.

In the section that you want to count, add a field with record source '=1' and make it a running total for the group.

In the header (one level up from where the running total resides) add a field with record source =Max(RunningTotalField)

Although the 'intellisense' sees my 'RunningTotalField' when I create the above mentioned formula, when I run the report, its asking me to input the value for the 'RunningTotalField'?

Have I confused some concepts or am I on the right track?
 

Users who are viewing this thread

Back
Top Bottom