Count

G

Guest

My report is sorted by 3 fields (Insurance Type, ICN, Source) in the Footer I
have a count which gives me the cout per Insurance type =Count(1).
In the Detail I have a text box called NAME - Control Source
=Trim(formatfield([lastname]) & ", " & formatfield([firstname]))
I would like the footer count to be a count of names not insurance type.
Is this possible???? If so, what would I replace the =Count(1) with???

Thanks
 
G

Guest

Check the posting just a bit earlier than yours with a subject of "Obtain
total without dups". Does this thread match your specifications?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

grouping data in a report footer 1
Display Count 4
counting records 0
How to count records using count(*) in a chart report 3
Count Number of Subgroups in Group Header 3
Count or total a logocal field 5
Count or DCount used in a report 1
Show Maximum Number in Report Footer 1

Top