Hey all you guys thanks. I tried Wolfgang/s solution and it worked perfectly.
However I used his concept to create another expression with simular outcome
but it did not work
here is my expression I want to fix:
CalKGtoLBS: IIf([Kilograms]>=[CubicMeters]*800.92,[kilograms]*2.2046)
Here is what I want to do:
Again I want to accomplish if [Kilograms]>=[CubicMeters]*800.92 or if
[cubicmeters] is null use ,[kilograms]*2.2046) otherwise use null
again my expression is missing out "or if [cubicmeters] is null" I tried
several what arnt I getting?
Here is one expression I made copycatting wolfgang's expression:
CalKGtoLBS: IIf(([Kilograms]>=[CubicMeters]*800.92 Or ([CubicMeters] Is
Null),[kilograms]*2.2046),Null)
but when I ran the query it says "Syntax error "comma" in query expression
Help
Wolfgang Kais said:
Hello.
Levans digital said:
How can I write (If [pounds] >= [cubicfeet]"50 and if [cubicfeet] is
null use [pounds] otherwise the field is empty.
Below is what I have. I suspect I am missing the part "and if [cubicfeet]
is null" please help.
CalLBS: IIf([Pounds]>=[Cubicfeet]*50,[pounds],"")
IIf(([Pounds]>=[Cubicfeet]*50) or ([cubicfeet] is null),[pounds],Null)