I am trying to do an IIf function within a form in access, but I don't think the syntax is correct. When I view it in form view it just displays the actual formula and not the answer. Any suggestions
=IIf([txtRawMaterial]= "MA"," Sum([Blocks])*50","Sum([Blocks])*55.115")
I assume that you have created a text box for you field, is the formula in the Control Source in the properties, or have you typed it as text in the box If the formual is not in the Control Source try typing it in there.