Im currently working on a small database
i have a cell that look up for 4 different data MONTHLY, QUARTERLY, SEMI ANNUAL and ANNUAL
if the mode of payment is Monthly i want access to multiply my inputed Client Premium to 12 and display it to (AGENTS APE Cell)
IIf([Mode of Payment]="Monthly",([Client Premium]*12),0)
no problem after saving but the Agents APE Cell is still "0"
PLEASE HALP