06-25-2011 12:06 PM
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.
Solved! Go to Solution.
06-26-2011 10:16 AM
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:
Value is: (SELECT ADDRESS1 FROM ADDRESS WHERE ADDRESS1 = ADDRESS2 )
Check 'Use Value as a literal'
Thats should do it!
06-27-2011 08:12 AM
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. ;-)]