AnsweredAssumed Answered

Count unique values within found set.

Question asked by EnriqueParedes on Jan 20, 2013
Latest reply on Feb 4, 2013 by philmodjunk


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?