You don't really say where you're trying to do this, but in a form
Me.BonusDate = DateAdd("yyyy",1,YourHireDate)
or in a query
BonusDate: DateAdd("yyyy",1,[YourHireDate])
Linq ;0)>
hi!
Thanks Linq! i have already done this inside the query.
BonusDate: DateAdd("yyyy",1,[dlcfrom]) and also [Salary]+100 in another field.
I have also done a NextBonusDate: DateAdd("yyyy",2,[dlcfrom]) and [Salry]+200 for another next year.
kindly i would like to ask that what should i do if the years go to 5,6 or 10. I think the whole table or query will be messed up with such a huge number of fields. So in such case what should i do? should i go for it or is there any way to manipulate some other code so that it gives me Many years records in each row in one filed relating to One Employee. This will create a one-to-many relationship of Employees Table to the Salary Table.