Case Function

[Niteshift]

If Month Ref is janvier and Year Ref is 2002 then it should return de janvier de l'ann

[Niteshift]

fixed it!

Case( Month Ref="d

[BobWeaver]

Isn't it simpler to just do this:

"de " & Month Ref & " de l'annee "& Year Ref

or if the Month Ref may be empty:

Case(IsEmpty(Month Ref),"N/A","de " & Month Ref & " de l'annee "& Year Ref)