I am trying to convert this excel expression into an Access expression:
=IF(OR(B79="",B 62="", H7=""),"Require d Fields Incomplete",IF( AND(F87<20000,O R(J87>P14, B87>P37)),"Yes, this is a HIGH COST loan. Proceed to Step 5 Excluded Fees Test.",IF(AND(F 87>=20000,J87>P 12),"Yes, this is a HIGH COST loan.","No, this is NOT a High Cost loan")))
...
Steven Hayes
Last Activity: Jan 31 '11, 12:22 AM
Joined: Jan 30 '11
Location:
-
Steven Hayes started a topic How to fix "The expression you entered has the wrong number of arguments"?in AccessHow to fix "The expression you entered has the wrong number of arguments"?
Thanks for any help I'm new at this. I have the following excel statement:
=IF(B131="", "Input UFMIP", IF((B131-B133)<0, 0, IF(B131>0, B131-B133, 0)))
I tried unsuccessfully to convert to access:
=iff([UFMIP charges]=" ","Input UFMIP", iif([UFMIP charges]-[text1705],0,0, iff([UMFIP charges>0, [UMFIP]-[text1705],0)))
I rec'd this error message:...
No activity results to display
Leave a comment: