Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe
if( [Type Acces] = 'Mobile' and [Entité] = 'BO B2C',[Dern. modif par],
if ([Type Acces] ='fixe' and [Entité] = 'fixe', [Dern. modif par])
)
How are your two tables linked to each other?
the pb is not fixed yet. i will share my qvw tomorrow with the community
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
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
Thanks but it does not work
Maybe
if( [Type Acces] = 'Mobile' and [Entité] = 'BO B2C',[Dern. modif par],
if ([Type Acces] ='fixe' and [Entité] = 'fixe', [Dern. modif par])
)
Thanks swuehl