Round and Nz functions in same expression??

[swift]

I’m trying to use both the Round and Nz functions in the same expression in a query, having problems though. This is what I’ve got so far:

Texture: (Round([TEX]),Nz([TEX],1.5),1)

Basically I want to round up the TEX value to 1 decimal place, BUT if there is no value in the field then I want it to use 1.5 automatically.

At the moment I’m getting a syntax error – can someone help please?

Cheers

 

[JANR]

Texture: Nz((Round([TEX])),1.5)

JR

 

[swift]

Texture: Nz((Round([TEX])),1.5)

JR

Thanks JANR, with a little bit of modification to your code I got

Texture: Nz((Round([TEX],1)),1.5)

which works a treat!

Thanks

 

[namliam]

You have one ) to many

Round([TEX])