a+b+c not simple

[Steve Hughes]

Excuse my ignorance but I am trying to add the times in three columns into a fourth by this calculation



GrossTime: ([StartTime]+[EntranceTime]+[PerformanceTime])

Works OK when there is a value in each but there is not always a value in 'StartTime' and when this is the case it does not give me the value of the two other columns. What am I doing wrong?

[pbaldy]

Wrap any value that could be Null in the Nz() function.

[Steve Hughes]

I would never have guessed. Brilliant, works a treat. Many thanks.

[pbaldy]

Happy to help!