AnsweredAssumed Answered

Count unique values within found set.

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

Title

Count unique values within found set.

Post

     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?

Outcomes