Hi all, thanks for taking the time to read this:
I am currently trying to run:
BudgetMonth1: IIf(([Front Loaded?]="Yes") And ([MAIN BUDGET FOR YEAR]>" "),Round ([MAIN BUDGET FOR YEAR]/6),0,"")
However, it's not working, please could someone spare me 5 mins to see what i'm doing wrong?
I am learning access as I go, and prefer to use the expression builder at this stage!
Thanks very much
Ian