Simple Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tvh - 30 Dec 2004 08:11 GMT

This formula, =[TotalHours]+[TotalTravelTime], does not give me a total if
there's no number (even a "0") in the Travel Time control. Does anyone have
a better formula that I should use? Or, should I change something in the
table properties? I tried changing the default value to zero, but that
doesn't work, either. Thanks in advance! (I love you people:)

Reply to this Message

Herbert Chan - 30 Dec 2004 09:50 GMT

I guess that those fields may contain nothing. As such, you have to change
it to as follows:

=Nz([TotalHours], 0)+Nz([TotalTravelTime], 0)

Herbert

> This formula, =[TotalHours]+[TotalTravelTime], does not give me a total if
> there's no number (even a "0") in the Travel Time control. Does anyone have
> a better formula that I should use? Or, should I change something in the
> table properties? I tried changing the default value to zero, but that
> doesn't work, either. Thanks in advance! (I love you people:)

Reply to this Message

tvh - 30 Dec 2004 10:01 GMT

Thanks, Herbert! It works!

Now I can get some sleep....
T-

> I guess that those fields may contain nothing. As such, you have to change
> it to as follows:
[quoted text clipped - 9 lines]
> > table properties? I tried changing the default value to zero, but that
> > doesn't work, either. Thanks in advance! (I love you people:)

Reply to this Message