p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access VBA (http://p2p.wrox.com/forumdisplay.php?f=80)
-   -   using a expression causing frustration (http://p2p.wrox.com/showthread.php?t=45720)

s.wright July 26th, 2006 05:48 AM

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


SerranoG July 26th, 2006 03:37 PM

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


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


All times are GMT -4. The time now is 02:15 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.