IIf function within MS Access  
Author Message
traci779





PostPosted: Visual Basic for Applications (VBA), IIf function within MS Access Top

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")

Thanks!



Microsoft ISV Community Center Forums3  
 
 
ADG





PostPosted: Visual Basic for Applications (VBA), IIf function within MS Access Top

Hi

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.