Can I add different Fields together

T

Trial & Error

I have several fields in a table, all containing numbers from identical
lookup columns. I also have , or would like to have a field that would
collect and automatically total each of the other fields.

The fields contain points awarded for each month, over a 4 mont period.
I would like the total field to display a continuously updated value that is
the sum of the other four fields. This data would all be contained within a
Table... hopefully searchable through queries.

ie.
December Points [lookup]
January Points [Lookup]
February Points [Lookup]
March Points [Lookup]
Total Points {sum of above 4}

is this possible?!
 
S

Sprinks

Trial & Error,

You don't need need a total "field" to store this sum in your table, but you
can create a calculated field in a query, or a calculated "control" on a form
or in a report to display this total:

In query design view, in a blank column, type the following in the Field row:

MySum: [DecemberPoints]+[JanuaryPoints]+[FebruaryPoints]+[MarchPoints]

Then base your form or report on this query. You could also place a
calculated control on a form with the Control Source equal to:

=[DecemberPoints]+[JanuaryPoints]+[FebruaryPoints]+[MarchPoints]

Hope that helps.
Sprinks
 
Top