Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Supressing duplicate fields in a cross table

Status
Not open for further replies.

agreen10

IS-IT--Management
Oct 20, 2005
70
US
I have created a cross table to list contacts, contact roles, email address, phone numbers. However, a contact that has two or more roles, their email address is printed three times for each rold. How can I get it to only print one email address for the contact?

Thanks for your help.
 
Group by contact code?

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top