iif #Error then

[mattc66 via AccessMonster.com]

I have a query that may result in a linked table with no data. The result it
gives me is #ERROR. I want to change the message to be TBD.

I tried the below IIF statement and I still get the #ERROR.

PO DUE: IIf([DUE DATE]="","TBD",[DUE DATE])

I also tried the =0 and I still get the #ERROR.

PO DUE: IIf([DUE DATE]=0,"TBD",[DUE DATE])

Any ideas?

 

[Guest]

Try this --
PO DUE: IIf([DUE DATE] Is Null,"TBD",[DUE DATE])

The double-double quotes is a zero lenght field and is not the same as a NULL.

 

[mattc66 via AccessMonster.com]

I get the same #ERROR.

Try this --
PO DUE: IIf([DUE DATE] Is Null,"TBD",[DUE DATE])

The double-double quotes is a zero lenght field and is not the same as a NULL.

I have a query that may result in a linked table with no data. The result it
gives me is #ERROR. I want to change the message to be TBD.

[quoted text clipped - 8 lines]

Any ideas?

 

[Guest]

You should try looking at the Nz function, i feel that this would fix it.
CurtainMary

I get the same #ERROR.

Try this --
PO DUE: IIf([DUE DATE] Is Null,"TBD",[DUE DATE])

The double-double quotes is a zero lenght field and is not the same as a NULL.

I have a query that may result in a linked table with no data. The result it
gives me is #ERROR. I want to change the message to be TBD.

[quoted text clipped - 8 lines]

Any ideas?

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.com

 

[Gina Whipp]

Is there another field in the table with PO DATE?

AND

Do you ever see the DUE DATE?

Gina Whipp

I get the same #ERROR.

Try this --
PO DUE: IIf([DUE DATE] Is Null,"TBD",[DUE DATE])

The double-double quotes is a zero lenght field and is not the same as a
NULL.

I have a query that may result in a linked table with no data. The
result it
gives me is #ERROR. I want to change the message to be TBD.

[quoted text clipped - 8 lines]

Any ideas?

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.com