dateadd in a table

[Nydia]

I'm in the process of creating a dba that tracks clients
in a program.

tbl1 has client info (name, ss#, address phone etc)
tbl2 has dates (start date, termination date and comments)
tbl3 is follow-up date with comments, here is what I am
having a problem with.

there will be 4 follow-up dates (a follow-up date 1 month
after termination date, 3 months after termination date, 6
months after termination date and 12 months after
termination date)

What I want to do is when a termination date is entered,
that the follow-up dates are automatically filled in. Is
this possible? If yes, How?

Thanks in advance,
Nydia

 

[John Vinson]

What I want to do is when a termination date is entered,
that the follow-up dates are automatically filled in. Is
this possible? If yes, How?

It's not possible in a Table; and it's probably not desirable in any
case, unless these follow-up dates are just defaults which you want to
be able to override.

To automatically calculate the dates dynamically, just store the
initial date and use a Query with expressions like

FirstFollowup: DateAdd("m", 1, [TerminationDate])

and similarly for the other followups.

I'd expect that this query could be used in a Form or Report to
display upcoming due dates; the followupdate in Table2 should probably
be manually entered, using the date the interaction actually occurred,
which might not be on the scheduled day.