Hello, I'm trying to write a sub query and I keep getting the division by zero error. I used an IIf statement but it's not working. Here's what I have:
IIf([Contracts Completed]=0,0,([Contracts Completed]/([Producing Time]/60)))
If you guys could help me out I'd appreciate it.
Thanks