In a Sub-Summary report, which is viewed in preview mode, How do I create a field which displays the summary of items listed in the report? In other words, if the Sub Summary report lists 10 items based off of say 20 records, How do I create a field that says "10" either in the header or footer? Any advice is much appreciated!!

Create a field that returns a 0 if the key field is empty, and a 1 if it is not. Then create a summary field that is the total of this first field. Put it in the summary part.

This is not what I'm looking for. This still gives me a total of the records in the report. If you use the example above, you still get a "20" instead of a "10". I'll try to explain myself better...

Example: If I have 10 records, 3 with the name "Joe", 2 with the name "Bill" and 5 with the name "Sue" and I want to create a preview report listing a summary of names, I would get a list of 3 names...

Joe

Bill

Sue

I'm in trying to create a field that states "3" for the number of items listed.

I hope this make some sense. Any advice is much appreciated!!

Create a self relationship based on your "name" field. Then create a calculation field NameCount = Count(SelfName::Name). Make sure the calculation is unstored.

The pitfall of doing this on a text field such as name is that if there are extra spaces before or after the name, you may get unexpected results.

HTH, Mike

It sounds like you want to create something similar to a duplicate record check, i.e. mark the first record that's unique and leave the remaining alone. This can be accomplished with a field whose calc is Min(SelfName::recordid) = recordid. Then create a summary total for this field and add it to a leading/trailing grand summary part.

I'll give these things a try, thanks for the feedback!

Would you be able to send a sample file of how this works?