Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

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

Discussion in 'Information Technology' started by Jack, Jul 28, 2006.

  1. Jack

    Jack
    Expand Collapse
    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
     
  2. Loading...


  3. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    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
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "Jack" wrote:

    > 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
     
  4. Jack

    Jack
    Expand Collapse
    Guest

    RE: How do I add one month to a date in Access when using a look-u

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

    Cheers,

    Jack

    "Jerry Whittle" wrote:

    > 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
    > --
    > Jerry Whittle
    > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
    >
    >
    > "Jack" wrote:
    >
    > > 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
     

Share This Page