Summing totals with a null value

[Access Beginner]

Hi
I have a query which I am trying to get a count of all activities.

The query is grouped by the field of Office. There are then fields called Engagement, On Site, Off Site, Visiting and Admin.

I have created a new field called Total Activity Count and used a calculated field to add these up, however if an Office does not have any values say for Admin, it is not totalling this up.

Is there anyway to get the calculated field to add up all fields, even if they dont have values for an Office?

I hope I have been clear, apologies if I haven't.

Any help is appreciated!

Using Access 2007

 

[alansidman]

In your calculated field you will have to use the NZ function. Here is a quick explanation/tutorial on the NZ function.

http://www.techonthenet.com/access/functions/advanced/nz.php

Alan

 

[Access Beginner]

Thanks Alan,

Exactly what I was look for.

Cheers