Hi Guys, Im hoping someone can help me with this, Im trying to make an expression which will look at a coloumn in a query and see if its null if it is, i want it to calculate 75% of a figure.

So far it looks like this,
Expr1: iif(isnull[Works order No]),[Works order No]*0.75,=0

Can someone please help me along here, i have used access a bit i have just never performed an operation like this.

Cheers
Steve Wright

Expr1: Nz([Works order No], 0) * 0.75


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division