3 Replies Latest reply on Feb 4, 2013 4:29 PM by philmodjunk

    Count unique values within found set.



      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?