I see from the other emails that you found a solution.  But I hope you 
understand why the 3 variables you have below will ALWAYS give you the same 
value for every row in your report.  Your first variable basically says "give 
me 
the FullN value in Try2 for the first row you find with a dutyname that 
contains 'chair".  That will always return the first row it finds where 
dutyname contains 'chair'.  Your variation definition doesn't look at anything 
in 
the current row at all.

If you're looking at the duty in the current row, determining what it is, 
and then looking it up, I would think this would work:

vDuty           Duty
vChairman    fulln in try2 where dutyname contains 'chair'
chair            (IFEQ(.vDuty,'Chair',.vChairman, ' '))



Karen

 
> I'll just type them in Karen since, as Jan pointed out, I can't send them 
> the easy way.
> 
>   
> 
>  chair   fulln in try2 where dutyname contains 'chair'
> 
>  essay  fulln in try2 where dutyname contains 'essay'
> 
>  discuss fulln in try 2 where dutyname contains 'discuss'
> 
>   
> 
> 
> 

Reply via email to