Help with IIF function

by =?Utf-8?B?TmVydm91c0ZyZWQ=?= <NervousFred@[EMAIL PROTECTED] Aug 7, 2008 at 01:47 PM

I have the following:

IIf([Ownersch].[SMOHL]<1800,1800-[Ownersch].[SMOHL],3600-[Ownersch].[SMOHL])

Everytime I run this it gives me back an #error. 

I have messed around with it a bunch and have come to realize that its the

conditional having a less than or equal in it that is causing the error. 

Any help to get around this problem?

Thank you

10 Posts in Topic:

Help with IIF function

=?Utf-8?B?TmVydm91c0ZyZWQ

2008-08-07 13:47:02

RE: Help with IIF function

=?Utf-8?B?S0FSTCBERVdFWQ=

2008-08-07 13:54:09

RE: Help with IIF function

=?Utf-8?B?TmVydm91c0ZyZWQ

2008-08-07 14:16:01

RE: Help with IIF function

=?Utf-8?B?S0FSTCBERVdFWQ=