Return Zero Value

[Haynesey]

Hi,

In a query, I am using the following code to return the average length of each tenancy. This works fine unless the length is 0. If so, it only brings back 'blank'. How can I change this code to return a 0 value?

Tenure Length AVG: IIf([Average Tenure Length]>0,Format([Average Tenure Length],"Fixed",Format(0,"Fixed")))

Thanks in advance

Lee

 

[boblarson]

Tenure Length AVG: IIf([Average Tenure Length]>0,Format([Average Tenure Length],"Fixed"),Format(0,"Fixed"))

You put the parentheses in the wrong place.

 

[Haynesey]

Thanks, that worked great.

Cheers

Lee