How do I add one month to a date in Access when using a look-up?

[Guest]

I have a Table of Audit dates. I would like to have the next audit date auto
loaded into another table. This date is to be one month on from the last
audit date. How do i do this?

Cheers,

Jack

 

[Guest]

Check out the DateAdd function.

Debug.Print DateAdd("m",1, #7/6/2006#) = 8/6/2006

Watch out when the previous month has more days than the next month.

Debug.Print DateAdd("m",1, #1/31/2006#) = 2/28/2006

 

[Guest]

Sorry I am really new to Access! How do implement that?

Cheers,

Jack