HELP, need an expression for default value in a table.

[SteelDragon]

Hello All,

I have a default value in a table I need to be calculated from 2 other fields in that table. here is the SQL query that does it, but I cannot get it to work as an expression in the default value field.

UPDATE [ToP] SET [ToP].TOPWeight = ([ToP]![RWAttacker]+[ToP]![RWDefender])/2;


the query runs great, but I need this to work on an access database that is on a Cold fusion server. If I could get the field to auto update or take the change as data is entered that is what I require. Or if I can put a macro or something in a web page to kick off (trigger) the update that could work also. Is there ANY way to get a default value to be (x+y)/2 ??

SteelDragon

 

[vr]

Try

([ToP]![RWAttacker]+[ToP]![RWDefender])/2;

 

[tlbroadbent]

Why store a calculated value pn the table. It can be calculated in a query whenver needed. This is standard database design practice.

If there is an overriding reason for storing the calculated value, why not update the column when you store the record? Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.