Compare Address 1 to Address2

[TedMyers]

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

[AdamTravers]

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!

[TedMyers · Accepted solution]

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