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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
