This is an important question.
The answer is that you have the sum in a query; it does not belong in a
table.
Example: to sum the value of fields A, B, and C.
1. Create a query into your table.
2. In the query design grid, Field row, enter:
=[A] + + [C]
If you want Access to assume zero where a row is blank use Nz() to say so:
=Nz([A],0) + Nz(,0) + Nz([D],0)
If you have many fields across your table such as Week1, Week2, ... or
Employee1, Employee2, ..., this spreadsheet structure is not appropriate in
a relational database. You need to redesign your table so as to make a
related table where all the values go into different records instead of
different fields. This process is called "normalization", and is *really*
important to being able to query your data efficiently and flexibly.
