Displaying totals from a duplicates query on a report

[c.d.power]

Good afternoon,

I have a duplicates query that accounts for two different columns of data (gender and race). I have a summary report based on the same table and at the top I would like to display totals for each gender and race represented.

I’ve tried a Count IIF function in place of a query in the text box on the report, but these seem buggy and unreliable. Some return a count and some don’t. I’ve checked the formula and they look fine.



I appreciate in advance any help that anyone can provide.

[June7]

Need something to analyze. Provide formula. If you want to provide db, follow instructions at bottom of my post.

[c.d.power]

Thanks for the quick reply. I had spelled something wrong, so user error on my part. I will mark as solved.

I am having other issues with the DB, though, that may require someone to have a look at it. I will create a new thread and post with the DB attached.

Thanks for your help!