Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19

    Unanswered:

    Try this:

    Code:
    If Me.StartTime > Me.StopTime Then
      Me.LapsedHours = (DateDiff("n", Me.StartTime, Me.StopTime) + 1440) / 60
    Else
      Me.LapsedHours = (DateDiff("n", Me.StartTime, Me.StopTime) / 60)
    End If


    Welcome to dBforums!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  2. #2
    Join Date
    Dec 2015
    Posts
    2

    thanks

    Thank you, that worked. Not sure why I was over thinking this.
    Thanks again.

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Glad we could help!

    The problem with the function you were using is that it requires both date and time components for Start and Finish.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •