>Hi Fabio,
>
>>if yes, try
>
>

>INNER JOIN appdata!Ssmoney ;
>ON    m.cIsGrouped AND Ssperson.familyid=Ssmoney.familyid
>  OR !m.cIsGrouped AND Ssperson.personid=Ssmoney.personid
>

>The above one takes 50 seconds.
>

>INNER JOIN appdata!Ssmoney ;
>ON IIF(m.cIsGrouped,Ssperson.familyid,Ssperson.personid) =
>   IIF(m.cIsGrouped,Ssmoney.familyid,Ssmoney.personid)
>

>This one is instantanious (less than a second). Just very interesting how this can be such a difference.
>
Mel,

One reason these are faster is that you code required both sides of the equal sign to be evaluated.