Eliminate Duplicates In A Report

[SteveIdeas]

For the following data...

ABC Company Sally Jones
ABC Company Fred Smith
XYZ Company John Doe

We want a report that says...

ABC Company
XYZ Company

NOTE: Duplicate entries with the same company name would be eliminated from
the report. Yet, we do not want to have large spaces between the list of
company names.

How do we do that?

Thanks,

Steve

 

[Stefan Hoffmann]

hi Steve,

ABC Company Sally Jones
ABC Company Fred Smith
XYZ Company John Doe
We want a report that says...
ABC Company
XYZ Company

You need to group by the company name, e.g.

http://articles.techrepublic.com.com/5100-10878_11-6073861.html


mfG
--> stefan <--

 

[SteveIdeas]

Thank you, Stefan. -- Steve

hi Steve,

You need to group by the company name, e.g.

http://articles.techrepublic.com.com/5100-10878_11-6073861.html


mfG
--> stefan <--