Totalling values in a multitude of queries

[RAClarke]

I wonder if someone could kindly assist me with a query I am trying to build. I have a variety of queries that when run produce totals based on tick boxes in a form. My problem is that I want to calculate the overall total of all of these queries added together. I have discovered that if just one of these queries does not contain a value I am unable to produce my overall total figure. What can I do to resolve this problem?

 

[PaulBricker]

Without more info, I would say you need to look at the Nz() function.
Nz([MyField],0)
says if MyField is Null, put a 0 in.
That way, you don't have any blank fields to deal with.

Paul

 

[RAClarke]

Thanks for this Paul, but where is abouts is the function used and expressed in a query?

 

[PaulBricker]

Put this expression in a new column in your query.
MyNewField:Nz([MyField],0)

You can change the alias, MyNewField to anything you want as long as it's not the field name and you follow it with a colon :

Paul