is blank or meet criteria iif

[jedder18]

Access 2007
Win7

My expression

Passed: IIf([maxof%]>0.7,Yes,No)

but,

I also need to have it be true if that same field [maxof%] is empty or null

When I place isnull IIf(isnull([maxof%])>0.7,Yes,No))

it gives me all the records as true, even those less than 70%

Help please...

TIA.

Jennifer

 

[pr2-eugin]

Jennifer, First things first.. Your naming convention is not great.. Try to avoid using non standard symbols in the field names.. Next, IsNull() is a function that will return True or False.. What you need is Nz().. So try..

Passed: IIf(Nz([MaxPercent],[COLOR=Red][B]1[/B][/COLOR])>0.7,Yes,No)

 

[Brianwarnock]

If Jennifer wants true if null then she needs to replace the null by 1 not 0 as the statement is written.

Brian

 

[pr2-eugin]

Yup missed that bit.. Sorry Jennifer, I edited the code..

Thanks Brian..

 

[Brianwarnock]

No problem Paul , your doing the heavy work on the site these days with your rate of answering a slip now and then will happen, besides tests if the user is understanding what's going on.

Brian

 

[jedder18]

Excellent, You guys rock...
I'm with you on the naming fields.
So far into this, would have to edit lots of stuff, and will do, first wanted to get stuff working.
Thanks so much.