Calculation

  • Thread starter Thread starter Ron Banister
  • Start date Start date
R

Ron Banister

I have a database were I store Department personnel in. I
want to be able to take a date a add say 8 years for each
person. For example, Sailor #1 joined the Navy 06 July
1988, I want to show a target date of 8 years from that
date. Each sailor joined the Navy on different dates, and
I want to be able to automatically calculate these target
dates. Thank you.
 
I have a database were I store Department personnel in. I
want to be able to take a date a add say 8 years for each
person. For example, Sailor #1 joined the Navy 06 July
1988, I want to show a target date of 8 years from that
date. Each sailor joined the Navy on different dates, and
I want to be able to automatically calculate these target
dates. Thank you.
Click to expand...

Don't store this date in any Table, if it can be calculated from the
join date. Instead create a Query based on the table. If the date
joined is in the field JoinDate, put an expression in a vacant Field
cell in the query

DateAdd("yyyy", 8, [JoinDate])

If this eight-years-after is just a default which may be edited, then
you can run an Update query updating the target date field to this
same expression.
 
Back
Top