counting lines

[Jerre]

I just need to count how many records are in a report. Don't need totals,
just how many records are listed. I've done it before but can't remember how
and can't find it.

 

[fredg]

I just need to count how many records are in a report. Don't need totals,
just how many records are listed. I've done it before but can't remember how
and can't find it.

=Count(*)
will give you the total number of records in the report.
You can place it in the Report Header or Report Footer, or Detail
section.
Do NOT place it in the Report Page Header or Page Footer.

If you wish to number each record, then add an unbound text control to
the detail section.
Set it's Control Source to:
=1
Set it's Running Sum property to Over All.

It will show the running count of each record in the detail section.