i am trying to create an access database, the formula i am trying to use is
IIf( [sellers selection]="2", [Amount] /100*10,"0")
access gives an error the expression you have entered contains invalid syntax
not sure what is wrong with the formula