07-10-2008 12:53 PM - edited 07-10-2008 01:01 PM
I need to eliminate duplicates where the same name appears in different contact fields. ((ID/Status = "Customer"*)) AND (("Contact" !<> "Copy Contact")) does not work.
Thanks for your help!
07-10-2008 01:27 PM
07-10-2008 01:38 PM
The query works to give me a list of records that have "customer" in the ID/Status field, but I also have contact and copy contact fields. Some of those fields have the same names and I want to eliminate them from my results.
07-10-2008 03:07 PM
07-11-2008 06:31 AM
07-11-2008 08:56 AM
By the way, I don't know where the smiley face is coming from.
Sorry about that. It's a little bug in the software. You can use the source code button () in the graphical editor if you have problems. That will insert the code into a box in which the editor will not add formatting.
((ID/Status = "Customer"*)) AND ((Contact !<> "Copy Contact"))