Count unique values within found set.
I have 2 Tables
One with unique customer accounts, customer info
One with unique serial numbers, customer account, customer info
Tables have a relationship through Acct numbers.
I have created a report that counts the serial numbers by City then Zip code one the serial numbers table but I also need to add an Acct field to my report but I'm not able count unique entries on my serial numbers table where I'm drafting my report from. I can't pull the unique accts totals from the customers table because I'm not able to sort my records from both tables and work together at the same time. How can I fix this issue?