Combine IIf expressions

[summer]

Hello-

I would like to combine the following two IIf expressions:

=IIf(IsNull([Due Date]),"No")

=IIf([Due Date]>Now(),"OK","OUT OF CALIBRATION")

How do I accomplish that? I've tried semi-colons, commas, parentheses...

Can anyone help??

 

[Newman]

=IIf(IsNull([Due Date]),"No",IIf([Due Date]>Now(),"OK","OUT OF CALIBRATION"))

 

[summer]

Now wasn't that easy...

Thank you Newman!

 

[cagay]

Hello Newman,

Can you please help me on my query expression?

I have this expression working [(WT=THK*WIDTH)/1000*LEN/1000*7.85*QTY]

I have two TYPES to evaluate in order to get the weight (7.85 or 8)

TYPE: "CS"=7.85
TYPE: "SS"=8

I don't know how to write the IIF statement.

Many thanks for your help,
ca

 

[cagay]

Hello Newman,

Can you please help me on my query expression?

I have this expression working [(WT=THK*WIDTH)/1000*LEN/1000*7.85*QTY]

I have two TYPES to evaluate in order to get the weight (7.85 or 8)

TYPE: "CS"=7.85
TYPE: "SS"=8

I don't know how to write the IIF statement.

Many thanks for your help,
ca