Calculate Default Date in a Table

[Guest]

I want to calculate a date to add 1 month from that date. For example, filed
1 says 01/01/2006 and new date would be calculated into field 2 as 02/01/06.

Thanks

 

[Guest]

Very bad idea. You should seldom store derived data in a table. Instead you
should calculated it needed in a form, report, or query.

DateAdd("m", 1, #01/01/2006#) = 02/01/2006

DateAdd("m", 1, [YourDateField])

Be careful to know what you want for dates that are the 29th, 30th, or 31st
of the month.

DateAdd("m", 1, #31-Jan-06#) can not be 31-Feb-06 so Access makes it
28-Feb-06.