Question Locked

Storing Calculated Fields in Database 2007

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I was wondreing if it is possible to store calculated fields into a table from form?

Could anyone help please :(

2 replies

by tony hopkinson

Calculated fields are extras for display / information, that don't have a corresponding column in the table.

Create the underlying column, do the calc logic. Save as normal.

If it's not always, then create an underlying field and do the logic then copy it in. Of course that may impact your calculation.

This discussion is closed to new replies.