1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

compare dates in forms

Discussion in 'MS Access' started by Gostap, Dec 17, 2007.

  1. Gostap

    Gostap New Member

    Joined:
    Jan 5, 2007
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    0
    Hi there

    A question from a newbie, hope some one could help me.

    I have a table with some date fields in among others.
    One field is called “Start production” and another is called “Stop production”
    I want to do a comparison between “Stop production” and “Start production” at the NEXT Next record! It is meant to get an msgBox with a warning if time between “Stop production” and “Start production” at next record exceed e.g. 5 minutes

    recID Start production Stop production

    1011 2007-10-01 15:33 2007-10-01 16:11
    1012 2007-10-01 16:12 2007-10-01 18:32
    1013 2007-10-01 18:41 2007-10-01 19:13
    1014 2007-10-01 19:14 2007-10-01 21:36

    I hope it is not too messy!

    Best Regards

    Gostap
     
  2. caveatashish

    caveatashish New Member

    Joined:
    Dec 29, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    Hi

    you can use datediff function of the access while reteriving the record and check for the dirrerence
     

Share This Page