Hi
I am using Access 2010 on win 8
I have a basic report and in the group footer I would like to count the records for the filed called [policy number]. As this field returns duplicate records I would only like each specific policy number to be counted once in my total.
Please can someone help me as when I use in the control source =count([policy number]) then every single record is counted and I only want the unique ones counted.
I would really appreciate any help with this please
Richard