Welcome to SPN

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

Sign Up Now!

Automatic Copying of Date

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

  1. Aurora

    Aurora
    Expand Collapse
    Guest

    I am using Access 2003

    I am creating a Preventative Maintenance (PM) Database. Lets say a machine
    needs to be oiled every 180 days. The last time it was oiled was 1/1/06. I
    have a calculated field ("next PM" that adds the "last PM date" (1/1/06) to
    the "frequency" (180) days and says the "next PM" is due 7/1/06. This
    information now gets entered into the Database. But how do I now
    automatically copy the "Next PM" date (7/1/06) to the "last PM date" so that
    my calculated field will come up with the "next PM" date of 1/1/07.

    I am not real good with programming, so I hope there is a formula somewhere
    that will help me do this when I close the form or database each time.

    Thank you for any help you can give me - aurora
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Akal Takht concerned on drug addiction, copying during exams Breaking News Nov 5, 2013

  3. G. Vaught

    G. Vaught
    Expand Collapse
    Guest

    Are you keeping a running history or changing the 1/1/06 to read 7/1/06? If
    it is the latter, then create an update query to run after 7/1/06 that will
    update last PM date to the date in the Next PM.

    If you are keeping a running history, then you need to append the
    information.

    "Aurora" <Aurora@discussions.microsoft.com> wrote in message
    news:3B7D5AD4-27D8-42DF-99D7-1D2F4CAC539D@microsoft.com...
    >I am using Access 2003
    >
    > I am creating a Preventative Maintenance (PM) Database. Lets say a
    > machine
    > needs to be oiled every 180 days. The last time it was oiled was 1/1/06.
    > I
    > have a calculated field ("next PM" that adds the "last PM date" (1/1/06)
    > to
    > the "frequency" (180) days and says the "next PM" is due 7/1/06. This
    > information now gets entered into the Database. But how do I now
    > automatically copy the "Next PM" date (7/1/06) to the "last PM date" so
    > that
    > my calculated field will come up with the "next PM" date of 1/1/07.
    >
    > I am not real good with programming, so I hope there is a formula
    > somewhere
    > that will help me do this when I close the form or database each time.
    >
    > Thank you for any help you can give me - aurora
     
  4. Aurora

    Aurora
    Expand Collapse
    Guest

    I want to keep a running history. I know how to append. Do I append the "PM
    Due Date for record #1 to the Last PM Date of record #2? Is that what you
    are telling me? Aurora

    "G. Vaught" wrote:

    > Are you keeping a running history or changing the 1/1/06 to read 7/1/06? If
    > it is the latter, then create an update query to run after 7/1/06 that will
    > update last PM date to the date in the Next PM.
    >
    > If you are keeping a running history, then you need to append the
    > information.
    >
    > "Aurora" <Aurora@discussions.microsoft.com> wrote in message
    > news:3B7D5AD4-27D8-42DF-99D7-1D2F4CAC539D@microsoft.com...
    > >I am using Access 2003
    > >
    > > I am creating a Preventative Maintenance (PM) Database. Lets say a
    > > machine
    > > needs to be oiled every 180 days. The last time it was oiled was 1/1/06.
    > > I
    > > have a calculated field ("next PM" that adds the "last PM date" (1/1/06)
    > > to
    > > the "frequency" (180) days and says the "next PM" is due 7/1/06. This
    > > information now gets entered into the Database. But how do I now
    > > automatically copy the "Next PM" date (7/1/06) to the "last PM date" so
    > > that
    > > my calculated field will come up with the "next PM" date of 1/1/07.
    > >
    > > I am not real good with programming, so I hope there is a formula
    > > somewhere
    > > that will help me do this when I close the form or database each time.
    > >
    > > Thank you for any help you can give me - aurora

    >
    >
    >
     

Share This Page