Totalling issues

[mbrinser]

I have a query that has multiple products listed and when I try to do a total unless there is a value listed for each product then it won't total, so I have to go across and put zero's into the fields. Is there any way around this so that it will total even if not all fields are filled in?

Thanks

 

[Galaxiom]

USe this instead of just the filedname in your query: Nz([fieldname])
This converts Nulls to Zero

 

[mbrinser]

that worked perfectly, thank you