Hi, I know this is a fairly easy one. I really try to avoid asking answered questions, but I've honsestly searched through the forum with no results..

I have three statuses:
1 = Ongoing
2 = Complete
3 = Dropped

I want to force status 2, if IIf([EPsDL]/[TotalEps]=0;2;""), so that it would force on status 2, only when the calc. gives zero, and thus letting me change status freely, as long as the calc. is >0.
I don't know whether to use IIf, nor where to put it at all. Would it work in a query, and if so - where to put it?

Thanks in advance :)

You can perform your test in the Current event of a form that can set the value of your control and enable/disable other controls at your pleasure.