Calculated field

[Symont]

Hi, i'm doing a calculation field but i want to add conditional steps in the calculation.

This is for bibliographical references. My calculation is this:

TextStyleAdd ( AuteurNom; Uppercase) & ", " & AuteurPrenom & ", " & TextStyleAdd (Titre; Italic) & ", " & Reference & ", " & Annee

My problem is that if I don't have data in all the fields, it looks something like this: LASTNAME, , Title, , Year.

I'd like to find a way to add a comma only if the field before it is not empty.

So the same exemple will look like this : LASTNAME, Title, year

I pretty sure I can do something with the isempty function, but, i'm not exactly sure how.

Help would be appreciated

[SlimJim]

Along the lines you are suggesting replace the first "," by

If(IsEmpty(AuteurNom);"";",")

the second by

If(IsEmpty(AuteurPrenom);"";",")

the third by

If(IsEmpty(Titre);"";",")

and finally the last by

If(IsEmpty(Annee);"";",")

[Symont]

Works like a charm

Thanks