pyromaniac
Registered User.
- Local time
- Today, 14:35
- Joined
- Jun 26, 2015
- Messages
- 30
This is what I got but it gives #error
Expr1: IIf([query1]![field1]=0,0,[query2]![field2]/[query1]![field1])
It works without the IIF except for the need to catch the DIV/0 error
[query2]![field2]/[query1]![field1]
I also tried
Expr1: IIf([query1]![field1]<>0,[query2]![field2]/[query1]![field1],0)
The division works but seems like the IIF doesn't. Any ideas?
Expr1: IIf([query1]![field1]=0,0,[query2]![field2]/[query1]![field1])
It works without the IIF except for the need to catch the DIV/0 error
[query2]![field2]/[query1]![field1]
I also tried
Expr1: IIf([query1]![field1]<>0,[query2]![field2]/[query1]![field1],0)
The division works but seems like the IIF doesn't. Any ideas?
Last edited by a moderator: