IIf syntax issue

What is wrong with...

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

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

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

mx
0
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.