View Single Post
  #1 (permalink)  
Old July 26th, 2006, 05:48 AM
s.wright s.wright is offline
Registered User
 
Join Date: Jul 2006
Location: , Essex, United Kingdom.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.

Cheers
Steve Wright