totals field

[NAS]

I am trying to add a field on a database that totals the numbers in the
fields above it ie:
user1.....2
user2.....5
user3.....7
total.......14

I am fairly new to access so what would be the easiest way to do this?

 

[BruceM]

It's difficult to provide a general answer to such a question. Are user1,
2, and 3 fields in one record, or are they related to a parent record? If
they are fields in one record, this may be a good time to rethink your
design. In any case, are the numbers 2, 5, and 7 totals of otherwise
calculated, or are they fixed values, or what exactly?

If user1, 2, and 3 are related records you could place a text box in the
form or report footer. It's Control Source would be the expression:
=Sum([SomeField]
where SomeField is the field with the number in it.

If they are fields in one record the Control Source of an unbound text box
could be:
=[Field1] + [Field2] + [Field3]

This could be an expression in a query instead. At the top of a blank
column in query design view:
AddAll: [Field1] + [Field2] + [Field3]

Again, if they are fields in one record there is a good chance your design
needs to be reconsidered. This would be the time to do that. More details
about the database's purpose and structure would help.