Forum Discussion
Receiving #type! back on calculation
So I am a little stuck and would like to know if anyone can help me with the below Expression: IIf([Asset_Type]="1000",[Beginning Year]," ")+15 Ok, so for the above Expression I am receiving ...
No that won't work for several reasons.
#Type errors indicate an expression is incorrect for one or more datatypes used
If Asset Type is a number field then you'll need to remove the quotes around 1000
Also I assume Beginning Year is a number field so it can't be set to an empty string
To determine a better approach, is this expression in VBA code or a query?
