I have a numeric field that I add a value every year and this value will be accumulating.
I use this code but it isn't work
IIf ((Datepart("m",[dateEntered])= Datepart("m",now())),(IIf ([totalDaysWorked]>0 and [TotalDaysWorked]<=730),40,(IIf ([totalDaysWorked]>730 and [totalDaysWorked]<=1460]),80,120)),0)
but the result is name??
Thanks for your advice.
I use this code but it isn't work
IIf ((Datepart("m",[dateEntered])= Datepart("m",now())),(IIf ([totalDaysWorked]>0 and [TotalDaysWorked]<=730),40,(IIf ([totalDaysWorked]>730 and [totalDaysWorked]<=1460]),80,120)),0)
but the result is name??
Thanks for your advice.