How to enter a column in a table that calculates values in other c

D

Dale Fye

Don't!

Spreadsheets do that, databases (at least, most good ones) do not. If you
want a calculated field based on other fields in a table, then you need to
create a query, and add a computed value to a new column in the query.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.
 
K

Klatuu

You can't do that using a Jet database engine.
It can be done in Excel and it can be done in SQL Server using a trigger,
but in any case, don't. It violates database normalization rules to do so.
The current technique is to calculate the value when you want to display it
for human consumption on reports or forms and when you need to export the
value to an external destination.
 
Top