Help with expressions in default value

[Maja]

Hi there,
I am trying to add a calculation of 2 fields (Total Value x POW) in another field of my master table. So I built the expression (=Sum[Total Value]*[POW]) in the Default Value property of the Weighted Value field. I've tried it with and without "sum" and the brackets. No luck with any of it, as I get "error 3344: The database engine does not recognize either the field ,name. in a validation expression, or the default value in the table <name>". Interestingly, when I'm in the expression builder, it does not show any of the field names, I have to type that in manually. Note that this is the master (or primary) table everything else is built on.

Is there a way to get the Weighted Value field to be a calculation such as the one I'm trying to insert?

Appreciate any help.

Maja

 

[boblarson]

Sorry but you don't normally store calculated values in your tables. You get the values by using a QUERY when you need them. And a QUERY can be used in 99% of the places a Table can be used.




NOTE: There can be times where it is necessary to store calculated data (for example when building a web app with Access 2010), but in most cases, if you have the stored fields which make up the calculation, you don't store the calculated values.