M
mbing916
I have a big report that is listing customers and the reps/companies they
worked with. I need to find out which of the customers have worked with a
company more than once and if it was with the same company multiple times or
different companies. Any ideas how to do this?
I tried to do a duplicate query that shows when each customer shows up more
than once, but then I need to find out if it is the same company or a
different one. Another dup. query??
The reports are large otherwise I would probably have just used excel.
THanks in advance!
worked with. I need to find out which of the customers have worked with a
company more than once and if it was with the same company multiple times or
different companies. Any ideas how to do this?
I tried to do a duplicate query that shows when each customer shows up more
than once, but then I need to find out if it is the same company or a
different one. Another dup. query??
The reports are large otherwise I would probably have just used excel.
THanks in advance!