Forgive me my poor English as I live in Holland.

I have a question:

Is it possible to show the result of a calculution as text.

example: if the result of a calculation is < 12 the result shown has to be "Mini".

If the result of a calculation is 12 or 13 the result shown has to be "C-jeugd".

Can this be done in Filemaker.

Thanks!

Yes.

You would use something like this...

Case(

myValue < 12; "Mini";

myValue = 12; "C-jeugd";

myValue = 13; "C-jeugd";

"Above 13"

)

Note that this gives the text result "Above 13" as the default value when none of the previous conditions are matched.

Thanks TheTominator for your fast reply.

It works. But now I have another problem.

I have 2 fields in table Tb_naam.

Field 1 is a calculated field that shows the age of a player on the first of october this year.

Field 2 has to show the calculated field with the solution you provided.

When adding the solution to field 2, field 1 also show the text and not an number anymore.

I only changed field 2 and not field 1.

Any idea why?

Since you posted this under Conditional Formatting...

Mini.zip

Thanks a lot.

This solves my problem.