Access

[Aboss]

Hello,


I have state which gives results in figures. I would like to know how to add these results obtained
Thank you

iif(Mat1]=1; 2;5) 5 iif(Mat1]=1; 2;10) 10 iif(Mat1]=1; 2;13) 2 iif(Mat1]=1; 2;7) 7

[ranman256]

Your example makes no sense. The IIF is the Same.
but you can put values in a table with their conversion value ,
then just join the table with the main data table to convert the #.

[June7]

You have 4 fields named Mat1, Mat2, Mat3, Mat4? Each expression should reference a different field?

That is not a normalized data structure. If you want to add fields then do arithmetic. Field1 + Field2 + Field3 + Field4. Or each of the fields could be expressions you show.

[Aboss]

I have IFF expressions that give results. I want to know how to add up these results.

[davegri]

I would like to know how to add these results obtained

I want to know how to add up these results.

Just repeating your requirement doesn't help at all.

[June7]

Already told you in post 3 - do arithmetic.

[Aboss]

You have 4 fields named Mat1, Mat2, Mat3, Mat4? Each expression should reference a different field?

That is not a normalized data structure. If you want to add fields then do arithmetic. Field1 + Field2 + Field3 + Field4. Or each of the fields could be expressions you show.

Ok thanks it works