add 3 weeks to an date column in access table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there
The first response did not work on our database, I will try to explain again
what we need
We have a table with the following fields
ID, Date, Log, Description, DueDate

I need to add a formula or function into the Duedate that will add a date (3
weeks later) in there automatically when I enter a date into the first Date
field
What do I have to do, becausde the help option with the dateadd function
does not work?

regards
Casper
 
You really should not do this (save the calculated value) .. as it violates
the Normal Form ...
A non keyed field should not be dependant on another non keyed field in a
table ....

You should simply store the interval if it is subject to change over time ...
Then you calculate the due date when it is needed dynamically and on the fly
....
This can be done in a field expression in a query or directly in the control
source of a txtbox in a form or report ...

R. Hicks
 
Back
Top