sequential dates

[Guest]

Hi-
I am building a db and I need to calculate from today's date and add 14 days
for 11 instances. For example, today is 8/17/07 next box I want to
automatically calculate and add 14 days and the next box at 14 days to that
and so on.

Please Help!
Thanks

 

[George Nicholson]

= DateAdd("d", 14, Today())

or, since 1 Day = 1

= Today() + 14

Any valid date reference can be substituted for Today().

HTH,

 

[Guest]

George I think you will find that 'Today' is for Excel but Date() is for
Access.

 

[George Nicholson]

you are (of course) right.

Oddly enough I was thinking Now() where I used Today() anyway
(which would also be wrong but for a different reason)