Add a Field that Performs a Computation

[Guest]

Is it possible to add a field that does the following:


FieldA+FieldB+FieldD+FieldE Divided by
FieldA+FieldB+FieldC+FieldD+FieldE+FieldF

Thank you in advance.

 

[Rick B]

Yes, but not in your table.

As discussed often in these newsgroups, you do not store a calculated value
in a table. It is redundant. You are storing the 6 fields that make up the
calculation, so you can simply perform the calculation in your forms,
queries, or reports when you need the figure.

Read any of the hundreds of previous posts on "storing calculated value" if
you want more details.

 

[Guest]

In a query, form, or report, Yes. Well techically it would be a control in
the form or report.

In a table, No.

Of course 1 divided by FieldC+FieldF should give you the same results.

You also need to make sure that FieldA+FieldB+FieldC+FieldD+FieldE+FieldF
does not equal zero or you will have a divide by zero error.

It sure looks like a normalization problem in the making. You aren't
committing spreadsheet are you?