IIf syntax issue

What is wrong with...


Who is Participating?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
How about this:

IIf([txtATDemand] - ([txtWHqtyAT] + [txtATwipANDfgQty]) < 0, 0, ([txtATDemand] - ([txtWHqtyAT] + [txtATwipANDfgQty])))

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.