in my report i have a field that is a total that i get from a query. how would i force the null values to be displayed as 0?

If you go into the query and get to the field properties and go to Format. Put in 0;0;0;0. It forces the input to be 0 for neg, pos, 0, or null values.

thanks, that did the trick, sometimes i miss the easiest things