Row sums in query

[Leathem]

I can't seem to sum across the fields in a query. Each row consists of a name followed by ten number fields, and I'd like to get the total of the ten numbers in the row for that name. I've tried using an expression like check:field1+field2+field3..., but the sum is not displayed if any one of the fields in the row is blank (not all the fields in a row have numbers in them). I should add that while I use Access 2010 the result has to work on computers with 2007.

 

[John Big Booty]

Have a look at the Nz() function.

Your expression will end up looking something like;

Nz([Field1],0) + Nz([Field2],0) + Nz([Field3],0)

 

[Leathem]

Many thanks!! That seems to do it.

 

[John Big Booty]

Glad to hear