Summarizing the number of text entries on a report

[beacon]

Hey everybody,

I'm sure this is cake, but I'm still kinda stumped. I'm trying to summarize info on a report based on the number of entries on the report.

I have 5 fields: FName, LName, Program, SkillLevel, and PhoneNumber. Each of these fields make up one line of info on the report. I want to count the number of entries and summarize it at the end of the report. Do I have to have some kind of number field, maybe a hidden one, associated with the other details in order to count this?

Am I way off track? Like I said, this is probably simple, but Tuesdays are always my Mondays...

Thanks,
the beacon

[NeoPa]

Any TextBox in any report header section can have a formula

=Sum([Item])

where [Item] is a control from your detail section. Any aggregate function (Count; First; Last; etc) can be used in the place of Sum().

[beacon]

Thanks for the help. I actually thought I tried that, but I was probably entering it incorrectly. Me and my hastiness.

Anyway, thanks again. My report is complete...bwoo hahahahaha!!

[NeoPa]

No problems. Glad you got it sorted :)