Using Calculated fields to create a total of the fields indicated,

[Grumpy Ump]

I am trying to create a DB for my Brother in Law.
He's been using a MS Works DB, but he's now having to replace his current Windows 7 laptop with a Windows 10 OS.
MS Works is not supported.
I have tried to use [field1]+[field2]+[field3] etc. i need to be able to add together the figures from approximatly 18 fields.

The figure appears when all the fields are populated, but give incorrect or no answer when a blank field is present.

Can anyone tell me where I am going wrong?

[davegri]

This might make you less grumpy. Code will check for nulls and replace with zero.
NZ([Field1],0) + NZ([Field2],0) + etc.

[June7]

Arithmetic with Null returns Null.

Have to think this is not a normalized structure. Appear to have fallen into trap of "spreadsheetitis" - retaining a spreadsheet structure in a relational database. Probably should have a related dependent table where each of the 18 field inputs would be a separate record. Then an aggregate query to Sum records.