Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add a value every year to numeric field

Status
Not open for further replies.

tybbe

Programmer
Sep 12, 2003
4
0
0
US
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 think if you look at the right of '1460' you will see an extra ']'
 
Thanks Jyotko.

That's true. I corrected this part but it is not work yet. You know if I made some mistake in my code.
Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top