forcing null to 0

[xveganx007]

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?

 

[Ack]

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.

 

[xveganx007]

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