Why adding in a query stops after a few records

[PeterPfaffJCI]

I have created a set of linked tables that I am running a query based on them
and add several of the fields together. The query summing works for two
records and then stops ( I have three more records but no totals). The
unfair question is what have I missed? But more importantly Is there
anything that can be done to pick up the remaining records?

 

[Golfinray]

How are you adding? Sum, IIF statements or what?

 

[PeterPfaffJCI]

Total hours:[sun work]+[monwork]+[tue work] etc.

Is how I wrote it in the query.

 

[Jerry Whittle]

Well aside from a field for each day being a very bad idea.....

I bet that most people don't work 7 days a week. Therefore some of the
fields have null values. Can't add a null value so that would stop it. You
need something like:

Total hours:NZ([sun work],0)+NZ([monwork],0)+ etc.

Also are these fields number data types or text? If someone put in the word
'One' instead of the number 1, that could cause grief.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Total hours:[sun work]+[monwork]+[tue work] etc.

Is how I wrote it in the query.

How are you adding? Sum, IIF statements or what?