Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Copper Super Contributor
Posts: 23
Registered: ‎12-11-2010
Accepted Solution

Compare Address 1 to Address2

I would like to create a group in which I can find all accounts where address1 equals address2.

Then I would like to crate a similar group to locate equal contact addresses.

 

Thanks to anyone who can help me.

 

       Ted

Highlighted
Bronze Elite Contributor
Posts: 514
Registered: ‎03-24-2009

Re: Compare Address 1 to Address2

Hi Ted,

 

Within the Account or Contact level of the query builder add the Address.Address1 field within the condition tab and add/enter the following criteria:

 

Operator: IN

Value is: (SELECT ADDRESS1 FROM ADDRESS WHERE ADDRESS1 = ADDRESS2 )

Check 'Use Value as a literal'

 

Thats should do it!

 

Regards, Adam Travers
empath-e Services Limited
Highlighted
Copper Super Contributor
Posts: 23
Registered: ‎12-11-2010

Re: Compare Address 1 to Address2

Hi Adam,

 

THANK YOU!

 

Your suggestion worked well. Being able to locate the duplicate addresses allows me to do a "Replace Data" to erase the Address2 entry in 462 accounts from a database of 4874 accounts. Needless to say, you have saved me a TON of time.

 

[ It was necessary to include "address1 contains data" and "address2 contains data," but I was able to figure that out myself. ;-)]

 

Thanks again!

 

   Ted