Calculated Fields in a table

[rolypoly]

I have three columns where A is a number, B is a number and I want to make C = to the greater of the two. i.e. Col A = 10, Col B = 12 therefore Column C = Col B or Col A = 12, Col B = 10 therefore Col C = Col A

Please help

 

[pr2-eugin]

Calculated fields should not be in tables.. Please do not go ahead with this design.. This will cause more trouble than you could think.. Look at Allen Browne's explanation..

 

[rolypoly]

Thank you Paul. I still need to build an expression to auto populate Col C. Can this be done?

 

[pr2-eugin]

In a Form or Query absolutely.. but do not store it in the table.. If you want to use it in a Form create an unbound textbox, in its Default value.. use this condition..

=IIF([ColA]>[ColB],[ColA],[ColB])

Similar in a query but you need is an Alias for the field.. somthing like..

SELECT *, bestValue: IIF([ColA]>[ColB],[ColA],[ColB]) FROM yourTable;

 

[rolypoly]

Paul you are an absolute gentleman and a scholar. Thank you very much