division = error

[mkelly]

I have this calculation in my query:

ColorTime: [ColorTotal]/([ColorSpeed]*0.6)

However [color total] and [color speed] can be 0 and this gives me an error message.

How can I change it so that if they are 0 it will give me 0 for an answere?

all help appriciated.

 

[mohammadagul]

Try This
ColorTime: Nz([ColorTotal])/(NZ([ColorSpeed])*0.6)