condition in the field expression

[master_student]

Hi guys,

I need your help once again

I have a table that contains a list of employee by entitee

NoConcatenate

modif:

[LOGIN CRM]  as "Dern. modif par",

     Entité,

     NOM &' '& PRENOM as "fullname"    

FROM

xx

where  Entité='Réclamation';

I have an other table to define secutity acess on a field

acess:

load if (match id(n,k,i,h,), mobile, fixe) as typeacces

.....

Entité='Réclamation' ,they have mobile as typeacces

i have a table as you can see below : i need to add a condition in the derner.modif par field something like if Entité='Réclamation' ,and typeacces=mobile display the derner.modif par field else display the other entity

anyone could help me to put this in my expression

thanks

[swuehl]

How are your two tables linked to each other?

[master_student]

the pb is not fixed yet. i will share my qvw tomorrow with the community

[master_student]

I nee somthing like this with two conditions

=if([Type Acces] ='Mobile',if(Entité='BO B2C',[Dern. modif par],'No') ) and  instead of no I need if([Type Acces] ='fixe',if(Entité='fixe',[Dern. modif par]

Any answer please.

Thanks for your help

[#5]

something like this u need

if( [Type Acces]= 'Mobile' and Entité='BO B2C',[Dern. modif par],

if [Type Acces] ='fixe' and Entité='fixe' as Dern. modif par]));

Not very sure

[master_student]

Thanks but it does not work

[swuehl · Accepted solution]

Maybe

if( [Type Acces] = 'Mobile' and [Entité] = 'BO B2C',[Dern. modif par],

if ([Type Acces] ='fixe' and [Entité] = 'fixe', [Dern. modif par])

)

[master_student]

Thanks swuehl‌