expression with more than 1 criteria

[Guest]

I have a field in my query where it looks at another field and if that field
is less than 450 it puts that amount in the field but if it is more than 450
it puts in 450. That part works fine, however when the field is blank or
empty I want this field to remain empty also. Here is the expression I have
so far:
IIf([MannedTime]<450,[MannedTime],450)
What do I need to do to have this field remain empty if the field
[MannedTime] is empty.
Thanks for your help

 

[fredg]

I have a field in my query where it looks at another field and if that field
is less than 450 it puts that amount in the field but if it is more than 450
it puts in 450. That part works fine, however when the field is blank or
empty I want this field to remain empty also. Here is the expression I have
so far:
IIf([MannedTime]<450,[MannedTime],450)
What do I need to do to have this field remain empty if the field
[MannedTime] is empty.
Thanks for your help

You can nest IIf statements.

=IIf(isNull(MannedTime]),"",IIf([MannedTime]<450,[MannedTime,450))

 

[Guest]

Thank you, it worked

I have a field in my query where it looks at another field and if that field
is less than 450 it puts that amount in the field but if it is more than 450
it puts in 450. That part works fine, however when the field is blank or
empty I want this field to remain empty also. Here is the expression I have
so far:
IIf([MannedTime]<450,[MannedTime],450)
What do I need to do to have this field remain empty if the field
[MannedTime] is empty.
Thanks for your help

You can nest IIf statements.

=IIf(isNull(MannedTime]),"",IIf([MannedTime]<450,[MannedTime,450))

 

[John Spencer]

Reverse the logic. Nulls (empty) will fail the test (first argument) and
therefore will return the second option (the third argument).

IIf([MannedTime]>=450,450,[MannedTime])