Joined: 09 Jul 2008
Location: United States
Online Status: Offline
Posts: 5
Topic: How to compare duplicate data in same string Posted: 09 Jul 2008 at 12:20pm
I have a string that contains {address 1} line information. For record "B" where {secondary person} = "True". I need to return record "A's" ID if the value in (address 1) is the same and {secondary person} = "False". (This means they are the primary).
Any ideas?
Sasha Lewis
Database Development Manager
PKD Foundation
sashal@Pkdcure.org
Joined: 26 Jun 2007
Online Status: Offline
Posts: 104
Posted: 22 Jul 2008 at 6:34pm
Is it one row of data or two??
If it's two rows try something along these lines...
if
(({table.secondary_person} = "True") and
({table.address}=previous({table.address})) and
(previous({table.secondary_person}) = "False"))
then previous({table.ID})
else "alternate condition"
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum