I am doing a report on my clients
I have fields to calculate such as [age],[county], [ethnicity], [gender] etc.
I am working on the ethnicity..I can group them and do a running count over group but I want to summarize the total...for example, I have 20 white, 30 hispanic etc. In the detail section it lists each one by row..How do I just total the group
Where are you making this calculation? Calc fields generally need to go in a header/footer section. You could use a SUM(IIF(ethnicity = "some ethnicity", 1, 0)) to find the count of each ethnicity. Where this would go depends on the specifics of your layout.