using a expression causing frustration
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.