creating a calculated column

[bold01]

Hi everyone,

i wish to create a new column on my access form such that;

If value of column [Term]="01W" then column [Final tolerance] should = value of [Term]

BUT

If value of column [Term]="01M" then column [Final Tolerance] should= value of [Term]

AND

If value of column [Term]="02M" then column [Final Tolerance] should= value of [Term]



Any help would be highly appreciated thanks

[thhui]

Create a query first so as to get the calculated field

[bold01]

thanks for your reply. have actually got a query for it already with a new column, i just don't know how to put the expression together to give me what i want, could you help me with that? thanks

[thhui]

The logic seems
[Final tolerance]=[Term] always!?

[bold01]

Hi everyone,
I now have this query expression working for one column (Tolerance1WK)
Final Tolerance: IIf([Term]="01W",[Tolerance1WK])

but i don't know how to make the condition include the other two columns (Tolerance1M and Tolerance2M)

Any help please????

[bold01]

thanks again, I now have this query expression working for one column (Tolerance1WK)
Final Tolerance: IIf([Term]="01W",[Tolerance1WK])

but i don't know how to make the condition include the other two columns (Tolerance1M and Tolerance2M)

Any help please????

[thhui]

Is it "OR" condition?

[thhui]

Is it something like that:-

[Final Tolerance]: iif([Term]="01W",[Tolerance1WK], iif([Term]="01M", [Tolerance1M], iif([Term]="02M", [Tolerance2M], "")))

[bold01]

Perfect! perfect! i just copied your expression and it worked. i did not put the square bracket on "final tolerance" though. thanks for your time

but then, is there any way i can make final tolerance show the conditional format of whatever column it get value from? without this been done, the whole essence of the expression is almost useless....FINAL HELP PLEASE. Thanks

[weekend00]

columnName: "Tolerance" & [term]

Final Tolerance: iif([Term]="01W",[Tolerance1W], iif([Term]="01M", [Tolerance1M], iif([Term]="02M", [Tolerance2M], "")))

[bold01]

thanks weekend00, already did that and its working, but then, is there any way i can make column "final tolerance" show the conditional format of whatever column it get value from? without this been done, the whole essence of the expression is almost useless....FINAL HELP PLEASE. Thanks

[weekend00]

how do you want to show the conditional format? can you give an example?

[bold01]

hi weekend00, based on the expression you gave earlier, do u think there is a way i could make the fields in column 'final tolerance' to automatically have the conditional format properties of the field its getting values from?

[weekend00]

please give an example of how you want to show.