Calculating Field

S

Sue

I have a form for entering client information, which
included registration date. I want to have a button to
open a form showing the client's schedule, which may
include 20 days after the visit, 60 days after the visit,
120 days after the visit, etc). Does anyone have the code
to do the calculation?
 
W

Wayne Morgan

Check the DateDiff and DateAdd functions. However, if you are dealing with
whole days only, due to the way Access handles dates, you can simply add the
number to the date.

Example:
dteTenDays = #2/10/2004# + 10

dteTenDays will have the value 2/20/2004.
 
Top