I am trying to calculate the totals for rows in Access 2007. I know how to
add TOTALS row.
Access *is not a spreadsheet*.
If your table is designed with multiple fields all of "the same kind" of data,
so that it is meaningful to add fields across a row, your table structure is
almost certainly WRONG. "Fields are expensive, records are cheap"; if you have
(say) fields for January, February, March, ..., December which you want to add
up for a year total, you need to redesign your table so that you have twelve
*records* in a table, not twelve fields!
That said... in a Query you can put in a calculated field. In a vacant Field
cell in the query grid type an expression like
RowTotal: NZ([field1]) + NZ([field2]) + NZ([field3])
The NZ function will treat a blank field as if it were a zero - by default any
expression involving a NULL value returns NULL.
if you're trying to do the sum in a Table... reread my first line above. You
cannot and should not do so.
