Count

D

Dan @BCBS

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
 
D

Duane Hookom

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

Top