running totals

[EscapeUK]

I have some running totals however if one is not used and I try to add the total to another nothing is displayed.

so what I want to know is how can i replace the running total not used with a zero if it is not used. Thanks

 

[MalcolmW]

Just a guess - assuming your "unused" RT has a NULL value, then adding a number to it would result in NULL. That matches the symptoms, so you could try checking the IsNull() test, and if the RT is null, exclude it from the total. Malcolm
wynden@telus.net