by Spixxy on February 22nd, 2004

Spixxy

Question

Help answer this question below.

How can I make a certain field perform a calculation? For example, I want a certain field to be the sum of three other fields.

  • Like
  • Report

Answers. Showing one answer.

  • by frankied on April 11th, 2005

    frankied

    Assuming you have <Field1> <Field2> and <Field3>, you can provide in a query the following: =<Field1.value>+<Field2.value>+<Field3.value>

    It really is pointless to have an actual fourth field that has the sums of the three, as it would be redundant information. A query behaves just like a table, so any manipulation can be handled very easily. In addition, having a fourth static field in a table with the values of a calculation based on the contents of the record would require you to run a process to update the fourth field each time any of the other three fields are changed. By using a Query instead, the calculation is automatically performed, and you know that the fourth field is always accurate.

    Comments
    • Like
    • Report

    No comments. Post one | Permalink

Want to attach an image to your answer? Click here.

Did this answer your question? If not, then ask a new question or create a poll.

You're reading How can I make a certain field perform a calculation? For example, I want a certain field to be the sum of three other fields.

Follow us on Facebook!

Related Ads