Summing Subreport/Report with HasData

[mrssevans]

Rich...if you are out there please help

I have used the hasdata to help sum the information on a subreport, however, it will only display the last number totaled in the subreport.
The subreport displays several different bunches of data that are linked to the main data in the report, but I am really needing to find the total of all the people in the subreport. I will attach the database in a 97 format if anyone can help. The report I am needing help with is the Client Distribution Report...

 

[Rich]

You could use DCount on the underlying query

 

[mrssevans]

I will try that one and see if it produces the results that I am looking for. Thank you so much for your quick response!!!

 

[mrssevans]

After starting to work on the query I am not sure that the dcount function would work either. I have the records counted in the subreport query, such as each record has a 1 in that field so I just need a way to add it up. Can you think of any reason the formula that you suggested in your other posts would work in this situation? Thanks for the help, Sam