only get total of fields filled in

[guinness]

Ok here goes. I use a query to get the total of the hours that staff spend on different activities each week. The hours that they enter go into three different tables (delivery, design and admin). I've used colours to show what belongs to what table. Here's the formula at the moment:

total: [SumOfDelivery Hours]+[SumOfAssessment Hours]+[SumOfVerification Hours]+[SumOfReview Hours]+[SumOfELearning]+[SumOfDesign]+[SumOfMeetings]+[SumOfScoping]+[SumOfCourse Admin]+[SumOfAdmin]+[SumOf1-2-1]+[SumOfTeam Meetings]+[SumOfPersonal Development]+[SumOfTravel]+[Annual Leave]+[Authorised Absence]+[Sick]+[TOIL]

The whole thing falls down however if someone perhaps didn't have any admin for the whole week so doesn't make any entry on that table. Is there any way to make this query ignore any missing data and only total what's available?

Any help would be much appreciated

 

[guinness]

Thanks Bob

I'll try it just now. Might be a silly question but could I bracket the whole formula? i.e total: Nz([SumOfDelivery Hours]+[SumOfAssessment Hours]+[SumOfVerification Hours]+[SumOfReview Hours]+[SumOfELearning]+[SumOfDesign]+[SumOfMeetings]+[SumOfScoping]+[SumOfCourse Admin]+[SumOfAdmin]+[SumOf1-2-1]+[SumOfTeam Meetings]+[SumOfPersonal Development]+[SumOfTravel]+[Annual Leave]+[Authorised Absence]+[Sick]+[TOIL],0)

 

[guinness]

Thanks bob